Peter Chan
asked on
Problem to adjust sheet
Hi,
How to adjust these
How to adjust these
Using (SpreadsheetDocument spreadSheet = SpreadsheetDocument.Open(docName, true))
{
SharedStringTablePart shareStringPart;
if (spreadSheet.WorkbookPart.GetPartsOfType<SharedStringTablePart>().Count() > 0)
{
shareStringPart = spreadSheet.WorkbookPart.GetPartsOfType<SharedStringTablePart>().First();
}
else
{
shareStringPart = spreadSheet.WorkbookPart.AddNewPart<SharedStringTablePart>();
}
int index = InsertSharedStringItem(text, shareStringPart);
WorksheetPart worksheetPart = InsertWorksheet(spreadSheet.WorkbookPart);
Cell cell = InsertCellInWorksheet("A", 1, worksheetPart);
cell.CellValue = new CellValue(index.ToString());
cell.DataType = new EnumValue<CellValues>(CellValues.SharedString);
worksheetPart.Worksheet.Save();
}
to put specific value into one cell of a selected sheet with a provided name?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.