Hello everybody,
Today I want to share with you two approaches for working with Excel files:
How we might create Excel file in Acumatica using standard dll library of Acumatica website.
How we might import data from excel file to Acumatica using XLSXReader from PX.Data.dll library.
Examp...
Hello everybody,
today I want to document a few lines of code which can help to convert excel file to CSV file with help of OLE:
static void ConvertExcelToCsv(string excelFileName, string csvOutputFileName, int worksheetNumber = 1)
{
&...