Convert csv file to excel in unix

So what perl commands can be used to read the excel and write the same contents to a csv file. Most things that can be done in a shell script can also be done in a perl script and more. Please have a look at the link I sent, because that will answer your other question. Read csv file, convert the data and make one text file in UNIX shell scripting. I have input data looks like this which is a part of a csv file 7,,,"" 8,,,"" I need to make the output data should look like this and the output data will be part of text file: 7 A 8 B The logic behind the Need help to write a shell script to convert text file to excel file.

Hi Everyone, I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet. I was able to build this XML in oracle database. Basically need to build this XML Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before Thanks -Meera 1 Reply.

Convert excel file to PDF file using shell script. If yes Kindly help me on the code Thanks in advance!!! Feedback sent. Thank you for your vote. CSV Comma-separated values or character-separated values files are flat files which store tabular data through numbers and text in a plain-text form.

It is used to collect data from tables to be transported as input to other table-oriented applicat XLSX files are produced by the applications of Microsoft's Office suite, namely by the product called Microsoft Excel, a spreadsheet processing software that is known all around the globe.

Once you've installed these modules correctly, they should be available on the default Perl INC path, and you will not need to use any extra use lib lines. You can try with a python script which convert any ff - flat file to required file format. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Asked 5 years, 4 months ago. Active 4 years, 6 months ago. Viewed 4k times. This is sample script I am trying to execute. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Related 3.