I have a problem with the character << ’ >> in formulae.
I created an Excel sheet like this :
I filled the row data columns by hand and then add 2 formulae. No problem with that.
Before I continue, just notice the name of the first column has a simple quote and in the formula, this simple quote is replaced with a double quote.
I create a sample of code that open the excel filesheet and reads the cell below the name of the column (the goal is to read the formula)
public static void exemple2()
// i open the report
Workbook report = new Workbook(“C:\Users\lowia\Desktop\test.xlsx”);
// i list the table
ListObjectCollection tables = report.Worksheets.ListObjects;
// foreach table
foreach (ListObject aTable in tables)
for (int a = 0; a < aTable.ListColumns.Count; a++)
// i take the cell just below the cell that contains the name of the column
// and look at that cell
Cell uneCellule = report.Worksheets.Cells[aTable.StartRow + 1, aTable.StartColumn + a];
// if the cell below the name of the column has a formula, we write it on the console
Here’s the answer:
There is a problem with the first formula since it refers to a colum which has a simple quote in its name.
When i remove the simple quote in the name of the first column, everything works fine…
Can you guys fix that ? If yes, when ?
Thanks in advance,
Please check/follow up your other thread: