gsc Posted March 3, 2021 Share 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 Link to comment Share on other sites More sharing options...
rkmcswain Posted March 3, 2021 Share 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 Link to comment Share on other sites More sharing options...
BIGAL Posted March 3, 2021 Share Posted March 3, 2021 This is a later version has a 2020 revision GetExcel.lsp 1 Quote Link to comment Share on other sites More sharing options...
gsc Posted March 4, 2021 Author Share Posted March 4, 2021 8 hours ago, BIGAL said: This is a later version has a 2020 revision GetExcel.lsp 18.5 kB · 1 download Thanx, this is what I was looking for! Quote Link to comment Share on other sites More sharing options...
Terry Cadd Posted April 8, 2021 Share 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 Link to comment Share on other sites More sharing options...
gsc Posted April 9, 2021 Author Share 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 Link to comment Share on other sites More sharing options...
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.