FlowHeater Logo

FlowHeater Support Forum

simply more productive

Download the freeware version (10 Mb)

Up to 100,000 records can be processed with the freeware version!

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Excel Adapter Filename

Excel Adapter Filename 5 years 2 months ago #2287

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 5 years 2 months ago #2288

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.
Attachments:

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

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.
  • Page:
  • 1
Time to create page: 0.099 seconds