Dynamic data import / export

datenbank

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 3 years 11 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 3 years 11 months ago #2288

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

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.080 seconds