CSV TO XLS via OLE
Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: CSV TO XLS via OLE
Andy, There is a thread from Nov 19 entitled Export Form Data to Excel on Button Action that may help. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, January 10, 2008 12:39 PM To: arslist@ARSLIST.ORG Subject: CSV TO XLS via OLE Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: CSV TO XLS via OLE
Andy, The following is the content of my dde.ini file for sending data to Excel. Please note that the Path statement needs to point to your Excel.exe file (not mine). My dde.ini file is located in: C:\Program Files\AR System\Home. Yours may need to be placed in a different directory. Almost every time we load a new client this location ends up changing. [Xfer-Excel-File] Path=C:\Program Files\Microsoft Office\Office10\EXCEL.EXE Application=Excel Topic=system Format=TAB XFRDATA=File Command1=[OPEN(%f)] Also, please note that any column that Excel determines to be Numerical will lose all leading zeros (i.e. Request ID). There are several ways to resolve this issue, but that would be a different post. I hope this helps. Ron Fariss AIG Global Services Service Desk Automation 713-831-2365 (Office) 281-782-0979 (Mobile) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, January 10, 2008 11:39 AM To: arslist@ARSLIST.ORG Subject: CSV TO XLS via OLE Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are