Re: [U2] making a .csv file into an .xls file?
I chased my tail on this for a long time. Finally broke down and wrote up a small application for our staff that creates excel files as the output. It's very easy to do with vb or c# and the uniobjects library(s). On 1/16/06, Bruce Nichol [EMAIL PROTECTED] wrote: Tony, Cripes! I can't even copy and paste properly At 19:37 16/01/06 -0800, you wrote: Bruce, you mean this 2 month old RFC?: ftp://ftp.isi.edu/in-notes/rfc4180.txt Yes, that is indeed what I meant. So sorry, folks Mitigation: I was also talking to a publican at the time... T -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
accuterm would not a viable option for this project. Not that it wouldn't work, but, for this project is not a good choice for a solution. Thanks for the idea however, George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Ballinger Sent: Friday, January 13, 2006 3:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] making a .csv file into an .xls file? I think Accuterm can create a legit .xls file on a windows client with the FT utility. This is easily scripted from the UV side. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
see comments within -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gordon J Glorfield Sent: Friday, January 13, 2006 3:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] making a .csv file into an .xls file? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. How particular is the 3rd party software? Excel is happy to load a csv file that has had it's extension changed from .csv to .xls. Would that work for your needs? I tried changing the extension, and the program bombed out, it is specifically looking for an .xls format, otherwise it fails... :( Is there an easy way to automate Excel to load the .csv, then save as .xls Yes you can. Create a macro in an Excel spreadsheet that does the conversion. Have the Workbook_Open subroutine run the macro. Set the windows scheduler to open the spreadsheet at the desired time and viola! Problem is I would need UV to create the spreadsheet with the macro.. George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Doyle Sent: Friday, January 13, 2006 4:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] making a .csv file into an .xls file? On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. I'll have to look into this...I don't mind a PERL routine the unix side to create the .xls from a UV file. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Friday, January 13, 2006 4:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] making a .csv file into an .xls file? Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. How particular is the 3rd party software? Excel is happy to load a csv file that has had it's extension changed from .csv to .xls. Would that work for your needs? It's VERY particular. Is there an easy way to automate Excel to load the .csv, then save as .xls? Yes you can. Create a macro in an Excel spreadsheet that does the conversion. Have the Workbook_Open subroutine run the macro. Set the windows scheduler to open the spreadsheet at the desired time and viola! not sure if I can do this with a macro, as the file is not created on the windows machine, but rather on the unix side. As well, there is the possiblity that for security reasons, some of the PC's used to load this file, may possibly have macros disabled. And to start have very non-savvy people to override that feature could be very dangerous to our network. George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Excel isn't the problem, it's the other program, which won't open XML either. Thanks for suggestion, might be able to use that on future project (especially imbedding the formulas). George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik Sent: Friday, January 13, 2006 5:31 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] making a .csv file into an .xls file? Is there an easy way to automate Excel to load the .csv, then save as .xls? Or, your universe program can output an XML file which you then name to have an .xls extension. Excel will open that natively. In Excel, you can do a FILE | SAVE AS as an XML file to see what Excel is looking for in an XML format. With XML you can do all kinds of Excel things like embedding formulas, specifying fonts, colors, multi-rows within single cells, freezing rows/columns, etc. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
I recently looked into auto formatting text files ready for EXCEL, e.g., take a CSV file and change it to xls and at the same time format the columns widths etc. I know it can be done other ways, xml etc, but this way we could convert all out current reports without changing any code. There where a few utilities that could do this, they also convert from CSV to xls by simply calling the utility and specifying the name. Here is just one example, not the one I tested. http://www.softinterface.com/Convert-XLS/Convert-XLS.htm If you look for other software it must be able to do the business from the command prompt so it can be automated into you code. Create the report, issue the command and there you go, one xl file ready to use. Re andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 13 January 2006 20:46 To: u2-users@listserver.u2ug.org Subject: [U2] making a .csv file into an .xls file? Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
The convention, as I understand it, for handling embedded commas in of csv data is to wrap each datum in double quotes. This cheerfully introduces the problem of embedded double quotes in of csv data, of course, and the conventional solution is to substitute two adjacent double quotes for each double quote. Very easy to generate, but it makes writing csv parsing routines deplorable. Your parser has to have 1-character of read-ahead to distinguish an embedded double quote from the end of the cell. TAB-delimited files do avoid this situation, but bank on your not having tabs in your data. I am not aware of any conventional method for dealing with tab-embedded tab-delimited data. Almost makes XML seem like a good idea. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:01 -0800, Kent Walker wrote: George, Mike is right - a Perl script can make the conversion easy and highly automated. However, I like to use TAB-delimited output to avoid the occasional messy situation when valid data contains commas or quotes. Write the program or paragraph such that it generates a text file and then shells to the Perl program to do the conversion. ActiveState's Perl for Windows does have the Spreadsheet::WriteExcel and Text::CSV modules available. Let me know if you want some samples to hack. Kent At 01:02 PM 1/13/2006, Michael Doyle wrote: On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. On Windows, I can only presume that Visual Basic can generate Excel spreadsheets. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
The convention for specifying alpha data vs numeric data is actually to precede the data with a single quote, not to surround it with double quotes. As far as tab delimited data that includes tabs, since this isn't supported in cells anyway it's not a problem. Tony Gravagno, Nebula RD TG@ removethisNebula-RnD.com Michael Doyle wrote: The convention, as I understand it, for handling embedded commas in of csv data is to wrap each datum in double quotes. This cheerfully introduces the problem of embedded double quotes... TAB-delimited files do avoid this situation, but bank on your not having tabs in your data. I am not aware of any conventional method for dealing with tab-embedded tab-delimited data. ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Goo'day, At 16:28 16/01/06 -0800, you wrote: The convention for specifying alpha data vs numeric data is actually to precede the data with a single quote, not to surround it with double quotes. As far as tab delimited data that includes tabs, since this isn't supported in cells anyway it's not a problem. Tony Gravagno, Nebula RD TG@ removethisNebula-RnD.com Perhaps a quiet look at ftp://ftp.isi.edu/in-notes.txt wil help you in determining .csv standards Thankyou, Martin (private joke...) ... very apt and pertinent... today... Michael Doyle wrote: The convention, as I understand it, for handling embedded commas in of csv data is to wrap each datum in double quotes. This cheerfully introduces the problem of embedded double quotes... TAB-delimited files do avoid this situation, but bank on your not having tabs in your data. I am not aware of any conventional method for dealing with tab-embedded tab-delimited data. ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Bruce, you mean this 2 month old RFC?: ftp://ftp.isi.edu/in-notes/rfc4180.txt Technically speaking, there are no standards. From that very document: Due to lack of a single specification, there are considerable differences among implementations. Implementors should be conservative in what you do, be liberal in what you accept from others... That said, I did speak too soon. The convention I referred to is for use within Excel and doesn't work for CSV. I have a bit more helpful related info in response to Mark's inquiry. My best, T Bruce Nichol wrote: Goo'day, At 16:28 16/01/06 -0800, you wrote: The convention for specifying alpha data vs numeric data is actually to precede the data with a single quote, not to surround it with double quotes. As far as tab delimited data that includes tabs, since this isn't supported in cells anyway it's not a problem. Tony Gravagno, Nebula RD TG@ removethisNebula-RnD.com Perhaps a quiet look at ftp://ftp.isi.edu/in-notes.txt wil help you in determining .csv standards Thankyou, Martin (private joke...) ... very apt and pertinent... today... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Tony, Cripes! I can't even copy and paste properly At 19:37 16/01/06 -0800, you wrote: Bruce, you mean this 2 month old RFC?: ftp://ftp.isi.edu/in-notes/rfc4180.txt Yes, that is indeed what I meant. So sorry, folks Mitigation: I was also talking to a publican at the time... T -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
ftp://ftp.cedarville.edu/download/ Keith, I would like to examine this package it's uses ... how do I get a copy ??? Kim Colwell Director of Administrative Data Systems Danville Area Community College 2000 E. Main Street Danville, IL 61832 [EMAIL PROTECTED] 127 443-8769 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny Westminster, CO, USA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
The BAT file could open the CSV file in Excel then save as XLS and quit. Or you could have a startup macro in Excel that did the save and quit if the CSV file is on the command line; anyone else can open the XLS. You may need to rename/delete the existing XLS file first. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
I think Accuterm can create a legit .xls file on a windows client with the FT utility. This is easily scripted from the UV side. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Friday, January 13, 2006 11:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] making a .csv file into an .xls file? Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. How particular is the 3rd party software? Excel is happy to load a csv file that has had it's extension changed from .csv to .xls. Would that work for your needs? Is there an easy way to automate Excel to load the .csv, then save as .xls? Yes you can. Create a macro in an Excel spreadsheet that does the conversion. Have the Workbook_Open subroutine run the macro. Set the windows scheduler to open the spreadsheet at the desired time and viola! Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. Excel has that capture keystrokes in a macro capability built right in. George [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. On Windows, I can only presume that Visual Basic can generate Excel spreadsheets. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
Or you can use a PERL script to take a File that is delimited by @AM (rows) and @VM (columns) and create an XLS binary file. I currently do this on an HPUX 11.x running Unidata 6.X. Did I mention it was free? Email me offline if you would like details. Thanks, * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 [EMAIL PROTECTED] 2:45 pm 01/13/2006 Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
You can use the wizard in Excel to create a macro to change the file type and then call the macro whenever Excel is started up. Or you can use Automation to change the file type whenever Excel (or any Automation-aware application) is started. Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 11:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] making a .csv file into an .xls file? Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
I don't think Unisplat can create an xls from csv. Gordon J Glorfield [EMAIL PROTECTED] wrote: Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. How particular is the 3rd party software? Excel is happy to load a csv file that has had it's extension changed from .csv to .xls. Would that work for your needs? Is there an easy way to automate Excel to load the .csv, then save as .xls? Yes you can. Create a macro in an Excel spreadsheet that does the conversion. Have the Workbook_Open subroutine run the macro. Set the windows scheduler to open the spreadsheet at the desired time and viola! Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. Excel has that capture keystrokes in a macro capability built right in. George [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
George, Mike is right - a Perl script can make the conversion easy and highly automated. However, I like to use TAB-delimited output to avoid the occasional messy situation when valid data contains commas or quotes. Write the program or paragraph such that it generates a text file and then shells to the Perl program to do the conversion. ActiveState's Perl for Windows does have the Spreadsheet::WriteExcel and Text::CSV modules available. Let me know if you want some samples to hack. Kent At 01:02 PM 1/13/2006, Michael Doyle wrote: On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. On Windows, I can only presume that Visual Basic can generate Excel spreadsheets. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Is there an easy way to automate Excel to load the .csv, then save as .xls? Or, your universe program can output an XML file which you then name to have an .xls extension. Excel will open that natively. In Excel, you can do a FILE | SAVE AS as an XML file to see what Excel is looking for in an XML format. With XML you can do all kinds of Excel things like embedding formulas, specifying fonts, colors, multi-rows within single cells, freezing rows/columns, etc. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Cedarville university has a program called DOWNLOAD that can do both file types and others that works perfectly with UNIDATA... (It has never error-ed on me in 5 yrs.) It is free for higher ED institutions. I am not sure about the rest of the world... I bet it would work well for you. It can make DB2 and all kinds of file types... -Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Friday, January 13, 2006 11:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] making a .csv file into an .xls file? Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
Keith Johnson wrote: Cedarville university has a program called DOWNLOAD that can do both file types and others that works perfectly with UNIDATA... (It has never error-ed on me in 5 yrs.) It is free for higher ED institutions. I am not sure about the rest of the world... I bet it would work well for you. It can make DB2 and all kinds of file types... -Keith Keith, I would like to examine this package it's uses ... how do I get a copy ??? Kim Colwell Director of Administrative Data Systems Danville Area Community College 2000 E. Main Street Danville, IL 61832 [EMAIL PROTECTED] 127 443-8769 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
