Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Read MS Excel files without MS Office installation

Read MS Excel files without MS Office installation 5 years 3 months ago #2145

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

Re:Read MS Excel files without MS Office installation 5 years 3 months ago #2146

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

Re:Read MS Excel files without MS Office installation 5 years 2 months ago #2149

  • Derus
  • Derus's Avatar
  • Offline
  • New Member
  • Posts: 3
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 :)
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.073 seconds