Search This Blog

Friday, October 30, 2009

Creating a csv Report

Use the code as a frame work and do your own enhancements for creating a simple csv report.

&NewDirectory = " C:\temp\folder ";

CreateDirectory(&NewDirectory, %FilePath_Absolute);

& file = GetFile("C:\temp\folder\reportname.csv", "W", %FilePath_Absolute);

& file.WriteLine(",,,Heading of the File);

& file.WriteLine("");

&file.WriteLine(" File titles separated by commas");

Sql=Create sql();

While sql.fetch()

&file.WriteLine(Pass the variable container in a loop in case of multiple rows);

End-while;

2 comments:

  1. brinkka2011 says: I printed a lot of your blog out thanks my friend

    ReplyDelete
  2. brinkka2011 says: I have a comment right here although not about this post, it really is regarding the website layout. I believe you should alter every now and then to generate it intersting to folks.

    ReplyDelete