I am trying to generate a report using the EXL07 output format through the AdHocRunFEX REST method call. This call to this method returns a string which is an EXL07 format that I need to save to a file so I can open it. I'm having trouble figuring out how to save that string to a file correctly so that it can be opened up with EXCEL. Has anybody tried to do this? I am using Visual Studio 2015 C# to make the REST API to retrieve the string and save the string to a file. However, I am not able to save it in a way that it can be opened with EXCEL.

This message has been edited. Last edited by: Tamra,

md,

Here is something for you to review that may help with your question.

Code: Writing to a Text File (Visual C#)

Specifically:

// Compose a string that consists of three lines.
string lines = "First line.\r\nSecond line.\r\nThird line.";

// Write the string to a file.
System.IO.StreamWriter file = new System.IO.StreamWriter("c:\\test.txt");
file.WriteLine(lines);

file.Close();

Thank you for participating in the Focal Point Forum.

Kind Regards,
Tamra Colangelo
IBI Focal Point Moderator