Free Support Forum - aspose.com

Excel table column title- Formulas- simple quote '

Hi everyone,

I have a problem with the character << ’ >> in formulae.

I created an Excel sheet like this :Heberger image


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[0].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[0].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
if (uneCellule.IsFormula)
Console.WriteLine(uneCellule.Formula);
}

}
Console.ReadKey();
}

Here’s the answer:

Heberger image

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,
Best Regards,
Louis.


Hi,

Please check/follow up your other thread:
<a href="


Thank you.