Dear all,
I obtained thanks a discussion chain some mathcad macro's allowing to read any sheet from an excel file and I am using it very often.
Now I observe that although I can read any sheet of an Excel Table, I can do it only if I already know the names of the worksheets of the excel file.
It happens now thats some worksheet names are generated automatically. I would like to get a list of the worksheet name within an Excel file directly from within Mathcad
The second question regards the writing of data from Mathcad in an Excel file.
Is it possible to write data in a specific worksheet from an Excel file or even to create a new worksheet in the excel file and then write the data ?
Does anyone knows how to do it ?
I have Mathcad 14 presently (Will be Mathcad15 from April next year)
Thank you
P Bujard
