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

Dynamic Sheet Name in ExcelConnector 4 years 10 months ago #2306

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:

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

Dynamic Sheet Name in ExcelConnector 4 years 10 months ago #2307

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.

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.

Dynamic Sheet Name in ExcelConnector 4 years 9 months ago #2308

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

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

Dynamic Sheet Name in ExcelConnector 4 years 9 months ago #2309

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.

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