Jump to content
Sign in to follow this  
Moist

Reading an Excel file

Recommended Posts

Hello again,

Is it possible to use Autoit to read a .xls file without actually opening Excel? I only want to read its contents of a file saved on a server. I don't intend to write anything on it. I've see the UDF _Excel_RangeRead but I'm guessing that only works on opened documents.

Thanks.

Share this post


Link to post
Share on other sites

There are UDFs available to create Excel files but I'm not aware of an UDF to read Excel files.
If you have Excel installed, I suggest to use the Excel UDF and open the workbooks in read-only mode.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-09-05 - Version 1.5.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites
58 minutes ago, water said:

There are UDFs available to create Excel files but I'm not aware of an UDF to read Excel files.
If you have Excel installed, I suggest to use the Excel UDF and open the workbooks in read-only mode.

Yeah, thought so. I guess I will be using .csv files then. Thanks

Share this post


Link to post
Share on other sites

@Moist

If you are going to read a .csv file, then you could consider to use _FileReadToArray() with your separator char (; or , or @TAB...) :)

 


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...