How to concatenate 2 .csv files in 1 .csv file with multiple sheets using Batch commands

Question

There is a requirement in my project to automate some SQL queries and i did but after that one user came and ask that we do not want 2 separate .csv file we want 1 .csv file with multiple sheets

For eg. suppose there 2 .csv files "Text1.csv" and "Text2.csv" and we are sending this to users but they are coming back asking to do it like a "Text.csv" file with "sheet1" and "sheet2" sheets.

I have been using below

@echo off
cls
@echo *****************************Reports****************************
@echo.

sqlcmd -h-1 -S database -E -i "loc.sql" -o "loc2.csv"

sqlcmd -h-1 -S database -E -i "loc1.sql" -o "loc2.csv"

@echo Report is generated
@echo.

Note: I can not use any 3rd party tool like java or jscripts, neither i can use Visual studio for VBS, i have only option with batch cmd file

PS. if there is another kind of script that can write as a batch file without any need of 3rd party tool that will be great

zglin · Accepted Answer · 2016-09-01 18:05:49Z

0

This isn't possible as the CSV format doesn't support multiple sheets (presuming that you are trying to view the file in excel).

The most you can do with a batch script is append one file onto another

copy File1+File2 NewFile

answered Sep 1, 2016 at 18:05

zglin

2,9192 gold badges18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Rishabh Bhargav Over a year ago

Thanks for responding @zhqiat.... but this way.. i can not resolve the query of user, we were sending excel(.xlsx) files before this and in that we were putting data manually in tabs. so now if i am automating they want the same and exact, the way it was

Rishabh Bhargav Over a year ago

Or is there any way that i can create a excel file(.xls or .xlsx) through batch command?

Stephan Over a year ago

a csv file is a textfile only. There are no tabs. If you want tabs, you can't use csv files. You have to use "real" Excel files xls(x). But you can't process Excel files with batch, you have to use some other language (powershell might do the trick)

zglin Over a year ago

+1 to @Stephan XLSX files have to be created via a more high level language. You can try to use a batch script to call a vba script which creates your excel file.

Squashman Over a year ago

Vbscript and Powershell can both modify excel files.

|

Collectives™ on Stack Overflow

How to concatenate 2 .csv files in 1 .csv file with multiple sheets using Batch commands

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related