gergospel.blogg.se

TempExcelBuffer.AddColumn(csvbuffer.FieldCaption(Inventory), False, '', True, false, false, '', TempExcelBuffer."Cell Type"::Text) TempExcelBuffer.AddColumn("CSV Buffer".FieldCaption(Value), False, '', True, false, false, '', TempExcelBuffer."Cell Type"::Text)

TempExcelBuffer.AddColumn("CSV Buffer".FieldCaption("Field No."), False, '', True, false, false, '', TempExcelBuffer."Cell Type"::Number) TempExcelBuffer.AddColumn("CSV Buffer".FieldCaption("Line No."), False, '', True, false, false, '', TempExcelBuffer."Cell Type"::Number) Procedure SelectFileFromFileShare(Var TempCSVBUffer: record "CSV Buffer" temporary)įilename := FileMgt.OpenFileDialog(WindowTitle, '', '') ĭataItemTableView = SORTING("Field No.") ORDER(Ascending) Message('check import %1 ', Rec.GetValue(3, 5)) The sheet examples and code is given below that i have used for import.I tried export using report but not able to do that if you can help ,e it will be greatfull.thanks in advance. Export should be according to condition for multiple sheet and also want some hard code for first three cell. I have one csv/txt file i want that file to convert into excel using csv buffer and excel buffer.Firstly i want that file to import into csv buffer after that i want that file to be converted into excel using excel buffer i am able to import file into csv buffer but not able to export it into excel.