ExportDataTableAsString ignores boolean values

Hi folks,

first of all many thanks for this impressive product.


Here my issue:

ExportDataTableAsString ignores fields with boolean values and standard format
ExportDataTable export these values as a string column with appropriate ‘False’ and ‘True’ as values.

Since I can’t rely on the excel values, ExportDataTableAsString should also import boolean values as ExportDataTable

So far
Dominik

Hi Dominik,

Please try the latest hotfix. It’s fixed.

Hi Laurence,

it’s working now

thanks for this awesome support

Regards
Dominik

@IntedisTooling,
Aspose.Excel is discontinued and no more development is done. A new product Aspose.Cells has replaced it which is more efficient and rich in terms of features. This new product also supports exporting data to different formats from worksheet. Here is an example of using the ExportDataTableAsString function:

string filePath = dataDir + "Book1.xlsx";

// Instantiating a Workbook object
Workbook workbook = new Workbook(filePath);

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Exporting the contents of 7 rows and 2 columns starting from 1st cell to DataTable
DataTable dataTable = worksheet.Cells.ExportDataTableAsString(0, 0, 11, 2, true);

foreach (DataRow r in dataTable.Rows)
{
    foreach (DataColumn c in dataTable.Columns)
    {
        string value = r.Field<string>(c);
        Console.Write(value + "            ");
    }
    Console.WriteLine();
}

Following link provides more details about exporting data from worksheet in different formats:
Export Data from Worksheet

The lastest version of this product can be downloaded here for trials:
Aspose.Cells for .NET (Latest Version)

A runnable solution containing hundres of ready to run axamples can be downloaded here.