FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the Excel Adapter , which may answer your question: CSV export with grouping

Excel Adapter Filename

9 years 5 months ago #2287 by Heinz
Excel Adapter Filename was created by Heinz
Hi there,

I am using the following script to get the read (input) filename:

public object DoWork()
// get access to the READ TextFile Adapter
TextFileAdapter adapter = (TextFileAdapter)AdapterRead;

// return the filename for further processing
return Path.GetFileName(adapter.Filename);

It works for TextFileAdapters, for ExcelAdapter, I cast to the ExcelAdapter, but I then get an error that the "Filename" property is not available on the ExcelAdapter.

Is there a different propertyname?

Please Log in or Create an account to join the conversation.

9 years 5 months ago #2288 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Excel Adapter Filename
hi heinz,

yes, the excel adapter uses a different property name for this. you have to use "workbook" instead of "filename".

you can find out the valid property names by using the adapter property view in the designer . please have a look to the attachment.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Time to create page: 0.263 seconds

other Languages


FlowHeater Home

de en


Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook


 de en