Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Reading data from Excel sheet and need for Excel to be installed
Topic Summary:
Created On: 01/15/2014 11:46 PM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 01/15/2014 11:46 PM
User is offline View Users Profile Print this message

Author Icon
JamesHalinson
Expert (100-199)

Posts: 122
Joined: 12/11/2013

Hi,

To be able to use the Excel reading and writing of spreadsheets does a full version of Excel need to be installed? If so, are all versions supported?

If we wanted to read sheets only and write the data out to a database is Excel viewer sufficient?

Thanks,

James 

 01/16/2014 11:08 AM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hi James,

Excel does need to be installed on the machine in order to work with Excel.

Office XP or higher is supported.

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 01/16/2014 11:49 AM
User is offline View Users Profile Print this message

Author Icon
JamesHalinson
Expert (100-199)

Posts: 122
Joined: 12/11/2013

Thanks Ricardo, can you confirm that full Excel needs to be installed and not just Excel Reader (if we are only reading data from spreadsheets)

 01/16/2014 11:51 AM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hi James,

You will need the full version of Excel.

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 01/17/2014 02:10 AM
User is offline View Users Profile Print this message

Author Icon
JamesHalinson
Expert (100-199)

Posts: 122
Joined: 12/11/2013

Thanks, is there any plan to be able to read/write XLS files without the need for Excel? We have had problems in the past with this and Microsoft don't advise running Excel on Servers, see this link

https://support.microsoft.com/kb/257757

Any thoughts on converting XLS to CSV to get around this?

 

 01/21/2014 09:43 AM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hi James,

I will pass this suggest to development.

I would suggest this possible workaround:

1) Get xls data into dataset (using database action)
2) Use file action to write it or us vbscript
3) Convert txt to csv.



-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 01/21/2014 12:24 PM
User is offline View Users Profile Print this message

Author Icon
JamesHalinson
Expert (100-199)

Posts: 122
Joined: 12/11/2013

Thanks Ricardo, to get xls into a dataset don't you need Excel installed?

 01/21/2014 01:24 PM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hi James,

You can run a query that will populate a dataset.

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 02/10/2014 07:04 PM
User is offline View Users Profile Print this message

Author Icon
NanaKlinton
n00b (>6 posts)

Posts: 5
Joined: 12/04/2013

HI there

I am looking for an easy method which supports to read Excel files effectively.I have tried to add one of the third party Excel reader to help out.But it can not work my windows 8 setup.So i want to know that if there is any powerful Excel tool which supports to do that directly.Thank a lot

 02/11/2014 06:47 AM
User is offline View Users Profile Print this message

Author Icon
Leonard Amabile
HelpSystems

Posts: 5454
Joined: 05/15/2007

Hi Nana,

If you are looking for an automated solution using AutoMate then Excel does need to be installed. If you are looking for another Excel viewer that does not require Excel to be installed, you may want to look at Quick View:

http://www.avantstar.com/



-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1777 guests browsing this forum, which makes a total of 1777 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog