gsc Posted March 3, 2021 Posted March 3, 2021 Hi, I have found some LISP examples which write list data to an existing Excel file (*.xlsx). But is it also possible to write list data to a new XLSX file with a chosen Filename and Sheet name? Quote
rkmcswain Posted March 3, 2021 Posted March 3, 2021 Have you seen the lisp file GetExcel.lsp by Terry Miller? An old link I had no longer works, but I found it here: https://github.com/cadavre/MTZ-BA-11_lisp/blob/master/sz/LSP/getexcel.lsp Should have what you need. Quote
BIGAL Posted March 3, 2021 Posted March 3, 2021 This is a later version has a 2020 revision GetExcel.lspFetching info... 1 Quote
gsc Posted March 4, 2021 Author Posted March 4, 2021 On 3/3/2021 at 11:35 PM, BIGAL said: This is a later version has a 2020 revision GetExcel.lsp 18.5 kB · 1 download Expand Thanx, this is what I was looking for! Quote
Terry Cadd Posted April 8, 2021 Posted April 8, 2021 (edited) The website http://web2.airmail.net/terrycad that hosted AutoLISP Exchange and GetExcel.lsp has been moved to the new domain https://autolisp-exchange.com . All programs and files are free to download and share. Just click on a button to view the program, then right-click and choose Save as... The direct link to the latest revision of GetExcel.lsp is https://autolisp-exchange.com/LISP/GetExcel.lsp . Edited April 9, 2021 by Terry Cadd Latest revision to date may change from time to time. Quote
gsc Posted April 9, 2021 Author Posted April 9, 2021 Thanx man, I also figured out how to save to XLSX: "SaveAs" ExcelFile$ -4143 "" "" :vlax-false :vlax-false nil replaced by: "SaveAs" ExcelFile$ 51 "" "" :vlax-false :vlax-false nil Quote
Seneca Posted April 11 Posted April 11 GetExcel.lsp is awesome, but the openexcel routine errors out if the excel file doesn't already exist and there is no other method in the suite to create a new Excel file which was the purpose of this forum post and now I still don't know how to do it. Quote
Seneca Posted April 11 Posted April 11 Apparently openexcel WILL create a new Excel file, you just can't include a file name as an arguement and I really need to learn to read. Quote
BIGAL Posted April 12 Posted April 12 Have a look at this it is multiple defuns. But open a file is there. Alan Excel library.lsp Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.