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: Read MS Excel files without MS Office installation

Read MS Excel files without MS Office installation 6 years 11 months ago #2145

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 298
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.

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.

Re:Read MS Excel files without MS Office installation 6 years 11 months ago #2146

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 298
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.

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.

Re:Read MS Excel files without MS Office installation 6 years 10 months ago #2149

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.

  • Page:
  • 1
Time to create page: 0.112 seconds