Skip to main content

Axapta Code to Import from Excel To Table.

Axapta Code to Import from Excel To Table.


 void importFromExcel()  
 {  
 myTable myTable;  
 COMVariant COMVariant1;  
 SysExcelApplication app;  
 SysExcelWorkbooks Workbooks;  
 SysExcelWorkbook Workbook;  
 SysExcelWorksheets Worksheets;  
 SysExcelWorksheet Worksheet;  
 SysExcelCells Cells;  
 SysExcelCell RCell;  
 int i;  
 #excel  
 app = SysExcelApplication::construct();  
 Workbooks = app.Workbooks();  
 COMVariant1 = new COMVariant();  
 COMVariant1.bStr("C:\\myExcel.xls");  
 Workbook = Workbooks.Add(COMVariant1);  
 Worksheets = Workbook.worksheets();  
 Worksheet = Worksheets.itemFromName("myTable");  
 Cells = Worksheet.Cells();  
 i = 2;  
 RCell = Cells.Item(i, 1);  
 ttsbegin;  
 while(RCell.Value().bStr() != '')  
 {  
 myTable.Field1Id = RCell.value().bStr();  
 RCell = Cells.Item(i, 2);  
 myTable.Field2 = RCell.value().bStr();  
 RCell = Cells.Item(i, 3);  
 myTable.FieldInt = str2int(RCell.value().toString());  
 RCell = Cells.Item(i, 4);  
 myTable.FieldReal = str2num(RCell.value().toString());  
 RCell = Cells.Item(i, 5);  
 myTable.FieldDate = RCell.value().date();  
 myTable.insert();  
 i++;  
 RCell = Cells.Item(i, 1);  
 }  
 ttscommit;  
 }  

Popular posts from this blog

Resolved : Power BI Report connection error during execution

Getting Below Power BI Report connection error during execution . Error: Something went wrong Unable to connect to the data source undefined. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: Business Sector. Underlying error message: AnalysisServices: A connection cannot be made. Ensure that the server is running. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: AnalysisServices Microsoft.Data.Mashup.ValueError.DataSourcePath: 10.10.10.60;T_CustomerMaster_ST Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: c72c4f12-8c27-475f-b576-a539dd81826a Request ID: dfb54166-c78f-4b40-779f-e8922a6687ad Time: 2019-09-26 10:03:29Z Solution: We found report connection not able to connect to SQL Analysis service so tried below option. Re

Song- Khamoshiyan Piano keyboard Chord,Notation and songs Lyrics

All songs notation and chords at one place

Song : O Saathi Re Film : Mukhathar Ka Sikkandhar Uses : C D D# E G A Note : The numbers at the end of the lines indicate line numbers. Pallavi: O saathi re, tere binaa bhi kya jina, tere binaa bhi kya jina A- C D D#....,D D C DD E...C..CA-...,D D C DD E...CC.......1 Play line 1 again phulon men khaliyon men sapnom ki galiyon men GGG...GAGE.. GGG G A G E.................................................2 tere bina kuchh kahin naa E A G E D C D D#.......................................................................3 tere binaa bhi kya jina, tere binaa bhi kya jina D D C DD E....C..CA-..., D D C DDE....CC.............................4 Charanam: har dhadkan men, pyaas hai teri, sanson men teri khushboo hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................5 is dharthi se, us ambar tak, meri nazar men tu hi tu hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................6 pyaar yeh tute naa GGG... GAG D#......E.........................