Hi,
I developed a class to convert xls format to csv. Manually it's executing but error in executing batch job.
Kindly help me in finding mistake in my code.
public void run()
{
Tri_EPaymentReturnTransaction ePaymentReturnTrans;
Tri_ImportTrial ImpTrial;
Name code;
Description Desrc;
int int1;
#File
CommaTextIo commaTextIo;
FileIOPermission permission;
container containFromRead;
int x;
int cols;
int record = 0;
int iCounter = 0;
#File
container readCon, name;
counter icount,inserted;
str checknull,a, extension, ExtFileName;
FileName fileName;
CommaIO csvFile;
int j = 0, i = 0, filecount, DelCnt = 0, filecountDel;
Tri_MessageType MessageType;
System.String[] files, filesDel;
Filename namefile, namefileDel;
SysExcelApplication application;
SysExcelWorkbooks workbooks;
SysExcelWorkbook workbook;
SysExcelWorksheets worksheets;
SysExcelWorksheet worksheet;
SysExcelCells cells;
COMVariantType type;
int row = 1;
Tri_ImportTrial importTrial;
FileIoPermission perm;
Tri_EPaymentReturnTransaction ePaymRetTrans;
BankParameters bankParm;
str filename1; //=@"C:\csv\";
#File
#Aif
application = SysExcelApplication::construct();
workbooks = application.workbooks();
select bankParm;
perm = new FileIoPermission(bankParm.Tri_ReturnSharedFolderPath,#io_read);
perm.assert();
if(WinAPIserver::pathExists(bankParm.Tri_ReturnSharedFolderPath))
{
files = System.IO.Directory::GetFiles(bankParm.Tri_ReturnSharedFolderPath);
filecount = files.get_Length();
for(i=0; i < filecount; i++)
{
namefile = files.get_Item(i);
name = fileNameSplit(namefile);
extension = conPeek(name,3);
ExtFileName = conPeek(name,2);
filename1 = @"C:\csv\" + ExtFileName;
if(extension == ".xls")
{
try
{
workbooks.open(namefile);
}
catch (Exception::Error)
{
throw error("File cannot be opened.");
}
workbook = workbooks.item(1);
worksheets = workbook.worksheets();
worksheet = worksheets.itemFromNum(1);
cells = worksheet.cells();
workbook.saveAs(filename1,6);
workbook.close(false, namefile);
application.quit();
}
}
}
