Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Dynamic Sheet Name in ExcelConnector

More
10 years 3 months ago #2306 by Heinz
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 to join the conversation.

More
10 years 3 months ago #2307 by FlowHeater-Team
Replied by FlowHeater-Team on topic Dynamic Sheet Name in ExcelConnector
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 to join the conversation.

More
10 years 3 months ago #2308 by Heinz
Replied by Heinz on topic Dynamic Sheet Name in ExcelConnector
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 to join the conversation.

More
10 years 3 months ago #2309 by FlowHeater-Team
Replied by FlowHeater-Team on topic Dynamic Sheet Name in ExcelConnector
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 to join the conversation.

Time to create page: 0.302 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.