Dynamic data import / export

datenbank

simply more productive
Up to 10,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.

TOPIC: Excel Adapter Filename

Excel Adapter Filename 3 years 3 months ago #2287

  • Heinz
  • Heinz's Avatar
  • Offline
  • New Member
  • Posts: 11
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?
The administrator has disabled public write access.

Re:Excel Adapter Filename 3 years 3 months ago #2288

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

Attachments:
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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.072 seconds