Announcements
790
Hi All, I hope all are doing good.
I need help on Using Dexterity to Export to Excel ,can any one please let me know the process how to do .Help will be appreciated.Hope waiting for your response.
Thanks
Nizamudeen
*This post is locked for comments
Wow Such a great help ,I will sure test and let you know the result.Thank you very very much.
local integer FileID; local string PathName; local text RowData; local long characters_written; local boolean result; PathName = "C:\Test\Sample.csv"; FileID = TextFile_Open(PathName, 1, 0); get first table SOP_LINE_WORK; while err() = OKAY do RowData = 'SOP Number' of table SOP_LINE_WORK + "," + 'Item Number' of table SOP_LINE_WORK + "," + Quantity of table SOP_LINE_WORK; characters_written = TextFile_WriteLine(FileID, RowData); get next table SOP_LINE_WORK; end while; result = TextFile_Close(FileID);
Above is a simple example of creating a CSV file with three columns of data grabbed from the SOP Line Work table. I wrote this quickly here as opposed to in a Dex script window, so forgive me if it does not compile, but it should be relatively accurate. The Dexterity Help File (Dex.chm) details the TextFile functions, refer to it for more detailed information.
Hi chadbruels,
Thanks for your input,one small request could please send me the steps how to do that..please ,i am new to this Technology. I have googled also i have not got any information,.If possible please send me the Step to my mail ID: nizamudeen.syed@outlook.com
If the layout you desire is very simple - basic rows and columns - you can simply use the text file functions to create a CSV file (TextFile_Open, TextFile_WriteLine, etc).
If you need to create a worksheet that is more complexe, in the Dynamics dictionary there is an ExcelObj form. I believe you should be able to use its form functions to create and populate an Excel workbook.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
