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.lsp 1 Quote
gsc Posted March 4, 2021 Author 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
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
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.