I am new in aspose . my code is using introp for excel and i have to convert into aspose. i am able to fond the suitable function in aspose. please provide the help on converting in aspose on below line of code.
Excel._Workbook workBook = null; Excel.Worksheet workSheet = null;Excel.Range cellRange = null; int priceCode = 0;
try
{
//Open new work book
workBook = ExcelApp.Workbooks.Add(Type.Missing);
// Get Reference to work sheet which is sheet 1
workSheet =(Excel.Worksheet) workBook.Worksheets[1];
workSheet.Application.ReferenceStyle = Excel.XlReferenceStyle.xlA1;
//
StringCollection headers = new StringCollection();
headers.Add("Survey Date(MM/DD/YYYY)");
headers.Add("Country ID");
headers.Add("Country Name");</p><p>
headers.Add("City ID");
headers.Add("Item Id");
headers.Add("Item Name");
headers.Add("Currency");
headers.Add("Low Price");
headers.Add("Medium Price");
headers.Add("High Price");
headers.Add("Average");
int asciiCode=65;
int row = 1;
for (int headersCount = 0; headersCount < headers.Count; headersCount++)
{
Char cellValue = Convert.ToChar(asciiCode);
cellPosition = cellValue + row.ToString();
((Excel.Range)workSheet.get_Range(cellPosition, cellPosition)).Value2 = headers[headersCount];
asciiCode++;
}v</p>