"{"Compressed part has inconsistent data length."}" this error occurred on that code. private string GetValue(SpreadsheetDocument doc, Cell cell) { string value = cell.CellValue.InnerText; if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString) { return doc.WorkbookPart.SharedStringTablePart.SharedStringTable.ChildElements.GetItem( int .Parse(value)).InnerText; } return value; } plz help me

this issue is resolved . Thanks, EveryOne helping me.

string value = cell.CellValue.InnerText; from this the value may be test or number .But you conver to int

Please try below link https://stackoverflow.com/questions/14729945/getting-an-error-meassage-system-io-fileformatexception-compressed-part-has-in

Answers

{"Compressed part has inconsistent data length."}

Kalyani Shevale

2.9k

"{"Compressed part has inconsistent data length."}" this error occurred on that code.

private string GetValue(SpreadsheetDocument doc, Cell cell)
{
string value = cell.CellValue.InnerText;
if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString)
{
return doc.WorkbookPart.SharedStringTablePart.SharedStringTable.ChildElements.GetItem(int.Parse(value)).InnerText;
}
return value;
}

plz help me