Dynamic data import / export


simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Excel Adapter Filename

Excel Adapter Filename 4 years 3 months ago #2287

  • Heinz
  • Heinz's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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 4 years 3 months ago #2288

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
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.


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
Moderators: FlowHeater-Team
Time to create page: 0.083 seconds