libraries for using Excel and Word files

[Marco_PeronXTBPH]

Hi everyone,
currently in the project I'm carrying out I use Microsoft.Office.Interop.Excel.dll and Microsoft.Office.Interop.Word.dll to create and edit xlsx, xls, csv, doc, docx, pdf files and so on.
the biggest "disadvantage" is that to work they need to have Excel and Word installed on the computer and also require the opening of applications (which obviously can be hidden but still remains a disadvantage in certain cases).
Does anyone know any libraries that can be used in Ilogic that have more or less the same functions but which do not require the installation of the Office package?

[WCrihfield]

Hi @Marco_PeronXTBPH.  That's a tough one.  I believe that we can still do some Excel related functionality with the GoExcel tools, when we have the Excel Engine option set to "Internal", instead of "COM", in the Advanced iLogic Configuration settings.  See the following online help page about that the settings in that dialog.  That dialog is accessed through the Tools tab, Options panel (may need to be expanded down), iLogic Configuration tool button.

https://help.autodesk.com/view/INVNTOR/2024/ENU/?guid=GUID-A65240D6-4854-42B9-B9A6-15453ACB5BC0 

[WCrihfield]

Hi @Marco_PeronXTBPH.  Since I do have Office 365, and do not have admin rights on work PC for installing random stuff, I can not (and have not) test any of the following, but in a quick search online, I came across a few links you might be interested in, as far as possibly being able to control Excel & Word type documents without having those specific applications installed locally, through .net API access.

https://stackoverflow.com/questions/15524512/net-read-word-excel-documents-without-microsoft-office-... 

https://learn.microsoft.com/en-us/office/open-xml/word/overview 

https://learn.microsoft.com/en-us/office/open-xml/spreadsheet/overview 

These other two seem to be extension packages for use with Visual Studio, so I am not sure if they would be accessible, or usable in any way from an iLogic rule.  However, I continue to find new things that can be done from an iLogic rule, even outside of Inventor, all the time.

https://marketplace.visualstudio.com/items?itemName=FilipK.GemBoxSpreadsheet33 

https://marketplace.visualstudio.com/items?itemName=E-iceblueCoLtd.FreeNETWordLibrary 

[Marco_PeronXTBPH]

Thanks for the reply, I'm looking in the links you gave me and I'm testing some dlls to see if they're right for me.
If I find anything useful I will update the post.