Forum Discussion
Excel inserts '@' Symbol into formulars, which breaks them
Hey Tech community, I am facing the following challenge and hope someone here can explain why it is happening and how to prevent the issue: I have created an Excel template that uses formulars to l...
I'm using VB.NET not VBA, don't think this is an option.
Doesn't Excel Interop use the same objects, methods and properties as Excel VBA?
- I'm not using Excel Interop, I may have to switch. I'm currently using the CloseXML package.
Unzip your excel file using "The Unarchiver" or something similar on windows.
Goto the xml file: /Book1/xl/worksheets/sheet1.xml
(path name and file name might be different based on your excel file name and sheet name).
Open the xml using some online formatter. Did you see "t=array"? if so, just write it as an array formula will work.
something like worksheet.cell(xxx).ArrayFormula = $""....
