web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Using Dexterity to Exp...
Microsoft Dynamics GP (Archived)

Using Dexterity to Export to Excel

(0) ShareShare
ReportReport
Posted on by Nizamudeen 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

I have the same question (0)
  • chadbruels Profile Picture
    chadbruels 1,588 on at

    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.

  • Nizamudeen Profile Picture
    Nizamudeen 790 on at

    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 

  • chadbruels Profile Picture
    chadbruels 1,588 on at 
    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.

  • Nizamudeen Profile Picture
    Nizamudeen 790 on at

    Wow Such a great help ,I will sure test and let you know the result.Thank you very very much.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans