bdr529 Posted June 30, 2015 Share Posted June 30, 2015 https://support.microsoft.com/kb/189897/en-us To community goes all my regards and thanks Link to comment Share on other sites More sharing options...
Zedna Posted June 30, 2015 Author Share Posted June 30, 2015 (edited) Data truncated to 255 characters with Excel ODBC driverhttps://support.microsoft.com/kb/189897/en-us Thanks.This explains problem with truncating values larger than 255 chars I discovered when testing this my UDF for creating XLS file.So problem is not in my UDF but in Excel itself. Edited June 30, 2015 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
Gianni Posted July 1, 2015 Share Posted July 1, 2015 nice function! Thanks Zedna.would be also very nice a companion function _XLSToArray() able to read data from Excel to an array (even if just raw data, not formula results of course...)p.s.I know that the great Excel UDF can do the job, but a lightweight function that has no need of Excel installed could be very practical sometime. Chimp small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt.... Link to comment Share on other sites More sharing options...
ViciousXUSMC Posted October 1, 2015 Share Posted October 1, 2015 Just grabbed this today for a project, the UDF works however for me its dumping like 12 testxxx.xls files along with my result file and opening excel up. I have no idea what that is about its like digging up old excel files from the past that had "test" as part of the file name. Happens every time I run it. First time I ran it I used "test.xls" as my file name so figured that is why, changed it to something totally different and it still dumps the 12 or so files with "test" in the file name. Including files I deleted ages ago. Link to comment Share on other sites More sharing options...
Zedna Posted October 4, 2015 Author Share Posted October 4, 2015 (edited) Just grabbed this today for a project, the UDF works however for me its dumping like 12 testxxx.xls files along with my result file and opening excel up.In example in my first post there is not only declaration of that function but also testing script at top of my code that calls _ArrayToXLS() 12 times and generates 12 XLS files and finally open it by calling ShellExecute().So just comment/remove these calls in your script.It's there only as example for people to see how to use it ... Edited October 4, 2015 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
ViciousXUSMC Posted October 5, 2015 Share Posted October 5, 2015 Ahh Ok, I went with _FileWriteFromArray and made a .CSV this time around. Next time I can use this. Link to comment Share on other sites More sharing options...
musicstashall Posted June 11, 2017 Share Posted June 11, 2017 Could you make the width of the columns adapt to the width of the text in the cell? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now