error when I export AutoCAD table to specific excel sheet ".xlsx"

error when I export AutoCAD table to specific excel sheet ".xlsx"

S_S_SS
Advocate Advocate
592 Views
5 Replies
Message 1 of 6

error when I export AutoCAD table to specific excel sheet ".xlsx"

S_S_SS
Advocate
Advocate

Hello every one 
I've a lisp code that export an AutoCAD table to a specific excel sheet with extension ".xlsx" or ".xlsm"
and it open the workbook and the worksheet  but it gives me error and doesn't export the data 
it should open this workbook and open sheet with name "input"
then export the data of the AutoCAD table to this sheet start from cell "A5" 
and save the sheet with the path of the DWG and with its name 
I'll upload the excel sheet and AutoCAD DWG
and thanks in advance 

0 Likes
593 Views
5 Replies
Replies (5)
Message 2 of 6

pendean
Community Legend
Community Legend
What's the error exactly? Post a screenshot of it please.
Message 3 of 6

marko_ribar
Advisor
Advisor

I don't know will it work for you, but in AutoCAD there is command "TABLEEXPORT", and it exports ACAD TABLE to *.csv file... I know that you have special requests, but maybe it's that simple, when you open *.csv in EXCELL, you just have to copy+paste data from to start from cell you want and then save it in *.xlsx...

Marko Ribar, d.i.a. (graduated engineer of architecture)
Message 4 of 6

S_S_SS
Advocate
Advocate

it open the workbook and work sheet but doesn't export 

M_H_G_M_G_0-1721409402422.png


the visual studio gives me this message 
[{
"resource": "/C:/Users/DELL/Downloads/EXPORT TO TABLE .XLSX.lsp",
"owner": "diagnostics",
"severity": 8,
"message": "ActiveX Server returned an error: Type mismatch",
"source": "",
"startLineNumber": 35,
"startColumn": 18,
"endLineNumber": 35,
"endColumn": 92
}]

 

0 Likes
Message 5 of 6

S_S_SS
Advocate
Advocate
thanks but what I need is a part of a big code that I made it's a step with more steps after this
so I need it to be exported Without my intervention
0 Likes
Message 6 of 6

Sea-Haven
Mentor
Mentor

Behind the scenes looking into this.