FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the OleDB Adapter , which may answer your question: Import/Export/Update of Sharepoint lists

Read MS Excel files without MS Office installation

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
11 years 5 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
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
11 years 5 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
11 years 4 months 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.261 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en