Hi guys,
i want to insert multiple record in import in excel below my code not working multiple record.
private void importStagingData()
{
int rowNo, counter;
HcmWorker worker;
str personId;
SDSStagingTable toInsert;
SelectableDataArea da;
OfficeOpenXml.ExcelRange columnVal;
OfficeOpenXml.ExcelRange colValNum;
rowNo=2;
if (dialog.run() && dialog.closedOk())
{
FileUpload fileUploadControl = dialog.formRun().control(dialog.formRun().controlId("Upload"));
FileUploadTemporaryStorageResult fileUploadResult = fileUploadControl.getFileUploadResult();
if (fileUploadResult != null && fileUploadResult.getUploadStatus())
{
stream = fileUploadResult.openResult();
using (ExcelPackage Package = new ExcelPackage(stream))
{
int rowCount, i;
Package.Load(stream);
ExcelWorksheet worksheet = package.get_Workbook().get_Worksheets().get_Item(1);
OfficeOpenXml.ExcelRange range = worksheet.Cells;
for (i = 0; i<= rowCount; i )
{
ttsBegin;
toInsert.clear();
toInsert.EMP = range.get_Item(i,1).Value;
toInsert.Person = range.get_Item(i,2).Value;
toInsert.EmplGroup = range.get_Item(i,3).Value;
toInsert.Nat = range.get_Item(i,4).Value;
toInsert.Gender = str2Int( range.get_Item(i,5).Value);
toInsert.Education = range.get_Item(i,6).Value;
toInsert.BloodType = str2Int(range.get_Item(i,7).Value);
toInsert.Religion = range.get_Item(i,8).Value;
toInsert.OldId = range.get_Item(i,9).Value;
toInsert.TransID = range.get_Item(i,10).Value;
toInsert.TransDate = str2Date(range.get_Item(i,11).Text, 123);
toInsert.AmountCur = any2Real(range.get_Item(i,12).Value);
toInsert.LedgerDimension = str2Int64(range.get_Item(i,13).Value);
toInsert.ValidFrom = str2Date(range.get_Item(i,14).Text, 123);
toInsert.ValidTo = str2Date(range.get_Item(i,15).Text, 123);
toInsert.Worker = str2Int64(range.get_Item(i,16).Value);
toInsert.TextA = range.get_Item(i,17).Value;
toInsert.TextB = range.get_Item(i,18).Value;
toInsert.TextC = range.get_Item(i,19).Value;
toInsert.TextD = range.get_Item(i,20).Value;
toInsert.TextE = range.get_Item(i,21).Value;
toInsert.DateA = str2Date(range.get_Item(i,22).Text, 123);
toInsert.DateB = str2Date(range.get_Item(i,23).Text, 123);
toInsert.IntA = str2Int(range.get_Item(i,24).Value);
toInsert.IntB = str2Int(range.get_Item(i,25).Value);
toInsert.IntC = str2Int(range.get_Item(i,26).Value);
toInsert.doInsert();
rowCount ;
ttsCommit;
}
}
}
}
info("@MPL426");
}
Thanks
