Welcome, Guest

See also the existing examples of using the Excel Adapter , which may answer your question: CSV export with grouping

Page:
1

TOPIC:

Excel Adapter Filename 7 years 11 months ago #2287

Heinz
Topic Author
Offline
Posts: 13

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.

Re:Excel Adapter Filename 7 years 11 months ago #2288

FlowHeater-Team
Offline
Posts: 368

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.