Read MS Excel files without MS Office installation
- FlowHeater-Team
- Topic Author
- Offline
- Admin
Less
More
13 years 2 months ago #2145
by FlowHeater-Team
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.
Read MS Excel files without MS Office installation was created 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]
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
- Topic Author
- Offline
- Admin
13 years 2 months ago #2146
by FlowHeater-Team
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.
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.
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.
- Derus
- Offline
- User
Less
More
- Posts: 3
13 years 1 month ago #2149
by Derus
Replied by Derus on topic Re:Read MS Excel files without MS Office installation
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
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