Kindly try this sample and let us know whether the issue is resolved at your end.
Mathu Mohan V A
STStephenHMay 9, 2017 01:57 PM UTC
OK, that put a file up there but no data :(This code should work right ?The values are in the worksheet when I debug print them ...
IWorkbook workbookUp = application.Workbooks.Create(1);
IWorksheet worksheetUp = workbook.Worksheets;
int rowcount = 0;
foreach (var item in tmpResult)
worksheetUp.Range["A" + rowcount].Text = item.InspectionItemDescription;
worksheetUp.Range["B" + rowcount].Text = item.Category;
worksheetUp.Range["C" + rowcount].Text = "Test comment " + item.OID;
worksheetUp.Range["D" + rowcount].Text = "Pass";
//Display the values
Debug.WriteLine(worksheetUp["A" + rowcount].Text);
Debug.WriteLine(worksheetUp["B" + rowcount].Text);
Debug.WriteLine(worksheetUp["C" + rowcount].Text);
Debug.WriteLine(worksheetUp["D" + rowcount].Text);
MemoryStream memstream = new MemoryStream();
memstream.Position = 0;
STStephenHMay 9, 2017 01:59 PM UTC
I have pasted the code formatted but it does not keep the formatting when I save it for some reason, am I missing something?
STStephenHMay 9, 2017 03:44 PM UTC
OK, I did some troubleshooting and autocomplete and referenced a similar variable above the one I wanted :(
The additional code segments you provided fixed my issue THANK YOU!
AVAbirami Varadharajan Syncfusion Team May 10, 2017 11:05 AM UTC
Thank you for updating us.
We are glad that the issue is resolved at your end. Please let us know if you need any further assistance.