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 Chart

Read MS Excel files without MS Office installation

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
13 years 2 months ago #2145 by FlowHeater-Team
Hi,

I have built with the help of FlowHeater free a tool that provides, from an Excel file, a formatted flat file in order to print labels for the delivery of packages. This tool works perfectly on my Windows PC with Microsoft Office.

I then wanted to install this tool on the server of the company, and use batch to start delivery with the files provided by customers. I’ve bought a FlowHeater licence but, problem, this server is equipped with the free Oracle Open Office instead of Microsoft Office. So I can read (despite my myopia ;-) Excel files on this server but FlowHeater cannot!

Is it possible to indicate to FlowHeater to use Open Office for read input file or must I buy a Microsoft Office license?

Best Regards,
Gilbert
[Request via Email]

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.

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
13 years 2 months ago #2146 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Read MS Excel files without MS Office installation
Hi Gilbert,

You could try to use the OleDB Adapter instead of the Excel Adapter ! This works without an MS Office installation on your server.

The OleDB Adapter needs for MS Excel files the following Connection string.

Office 2007/2010 Excel Files
Provider=Microsoft.ACE.OLEDB.12.0; Data Source=input.xlsx; Extended Properties="Excel 12.0 Xml; HDR=No"

Office 97-2003 Excel Files
Provider=Microsoft.ACE.OLEDB.12.0; Data Source=input.xls; Extended Properties="Excel 8.0; HDR=No"

NOTE: HDR=No = without field names header, HDR=Yes = with field names header

Try to make a connection test then switch to the tab "Fields / Data types". Here you can choose the available Excel sheet names from the combo box. After choosing a sheet name below you will see a SQL select like this

Select * from your_sheet_name$

This select you have to change to
Select * from [your_sheet_name$]

Or if you want to use a range
Select * from [your_sheet_name$A3:G100]

Now click the load schema button and the OleDB Adapter reads the containing field information. Now you can read from Excel files without an MS Excel/Office installation on your server.

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.

More
13 years 1 month ago #2149 by Derus
Hello,

Thank you very much,
Now FlowHeater works perfectly without installing MSOffice on my server.
The water is now warm without transfer to other containers :)

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

Time to create page: 0.263 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

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

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


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