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: Dynamic Sheet Name in ExcelConnector

Dynamic Sheet Name in ExcelConnector 2 years 11 months ago #2306

  • Heinz
  • Heinz's Avatar
  • Offline
  • New Member
  • Posts: 11
Hi there,

I am using the ExcelAdapter to read data from a xlsx file. My problem is that the sheet is provided by a third party and they tend to rename the sheet on each new file. Can I not access the sheet by index rather than name?

How would I get arroudn this, since the process falls over inthe automated env with an error that the worksheet named "x" is not found.
Attachments:
The administrator has disabled public write access.

Dynamic Sheet Name in ExcelConnector 2 years 11 months ago #2307

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Heinz,

Semiautomatic Workaround) You could use a FlowHeater Parameter for the Excel Sheet name like this $SHEET$. For testing purpose in the designer you should define a default value for this used parameter (Menu->Edit->Parameters). You can override this parameter by using the Batch Module

For example: FHBatch.exe /SetParameter SHEET=Your-Excel-SHEET-NAME your-excel-export-definition.fhd

For future) I´ll implement this feature with the next version.
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.

Dynamic Sheet Name in ExcelConnector 2 years 11 months ago #2308

  • Heinz
  • Heinz's Avatar
  • Offline
  • New Member
  • Posts: 11
Hi,

thanx for the info - but this would not solve the problem, since it still requires me to "know" the sheet name. Problem is with the external provider, they change it without notifying us, but it is always first.

When I deal with this in my own system, I access the sheet by index on not name.

Regards
heinz
The administrator has disabled public write access.

Dynamic Sheet Name in ExcelConnector 2 years 11 months ago #2309

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Now you could download a first BETA version of this new feature here.

This version supports Excel sheet indexes. In case the specified sheet name is numeric and the excel sheet name isn’t available in the current Excel workbook FlowHeater tries to get the Excel sheet by the index instead of the name.
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.076 seconds