Sign in to follow this  
Followers 0
xilace

Read exel without it installed

2 posts in this topic

Currently my script reads values from an excel file on a computer with excel installed. It converts it into csv, to the format that is needed. You then have to take that to the server to run step 2 where it reads the csv file.

I'm trying to take out the need of step one and have it be able to read excel directly without it installed. I have found the following useful http://blogs.technet.com/b/heyscriptingguy/archive/2008/09/11/how-can-i-read-from-excel-without-using-excel.aspx

That doesn't work for xlsx though. It would also require turning off code signing in powershell and of course incorporating powershell into my script. I'd rather not have to turn off code signing. I also cant sign the powershell script as we are always using this on different servers and the import/export would be to much on the techs to do.

Anybody have any other ideas or thoughts?

Thanks much in advance!

Share this post


Link to post
Share on other sites



Hallo.

Not sure is it that what you exactly want to do but i think this can be right direction.

IMHO if you have specified .csv file (generated by script) and if you need read it without excel i think right way would be using re-revers way for that file(structure).

I mean 'cut' some standart on fly from that file and then out it to any control for example.

Cheers.


[size="5"] [/size]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0