Incorrect formatting of string to decimal during Excel import

Question

I am making an excel import for a dataGridView and the formatting of the field type Value does not bring the comma, period and decimal place, example:

In the Excel it’s like this: 995.800,00 (certain) and after import into dataGrdiView gets like this: 995800 (wrong)

Relevant excerpt from Code c#:

FileInfo File = new FileInfo(txtArquivoOrigem.Text);
ExcelPackage package = new ExcelPackage(new FileInfo(txtArquivoOrigem.Text));
ExcelWorksheet workSheet = package.Workbook.Worksheets.First();

for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++)
{
    Cliente cliente = new Cliente();
    for (int j = workSheet.Dimension.Start.Column; j <= workSheet.Dimension.End.Column; j++)
    {       
        if (j == 9)
        {
            decimal faturamento;
            bool resultado = decimal.TryParse(workSheet.Cells[i, j].Value.ToString(), out faturamento);
            if (resultado)
                cliente.Faturamento = Convert.ToDecimal(workSheet.Cells[i, j].Value.ToString());
        }       
    }      
    lCliente.Add(cliente);
}

The value as it is in Excel:

I tried to implement the suggestion of Vik , but does not compile, returns the following error: None under load for the "Tostring" method takes 1 arguments. :

Answer 1

Maybe changing the formatting in the column itself (I named it "Billing"):

MyDataGridView.Columns["Faturamento"].ValueType = typeof(decimal);
MyDataGridView.Columns["Faturamento"].DefaultCellStyle.Format = "#,##0.00";

Answer 2

cliente.Faturamento = Convert.ToDecimal(workSheet.Cells[i, j].Value.ToString());

When using Tryparse, you already have the value in the variable faturamento... If the resultado for true:

cliente.Faturamento = faturamento;

use then . Tostring("n") to display in thousands separator format and two decimal places.

Standard Numeric Format Strings