Ovdje je vodič za pretvaranje CSV-a u XLS ili XLSX pomoću sučelja ^(interface)naredbenog retka^{(convert CSV to XLS or XLSX using the command-line)} u Windows 11/10 . Postoji više načina za pretvaranje CSV datoteke u Excel formate ( XLS , XLSX ). Za izvođenje konverzije možete koristiti Microsoft Excel , namjenski besplatni program za pretvaranje ili online alat. No, jeste li znali da također možete koristiti sučelje naredbenog retka sustava Windows za pretvaranje ^(Windows)CVS -a u Excel ? A, za to vam čak i ne treba nikakav alat treće strane? Ako ne, ovaj vodič će vas ugodno iznenaditi.

U ovom članku ćemo vam pokazati kako možete pretvoriti CSV datoteku u Excel radnu knjigu. Za to ćemo koristiti VBScript . Dopustite nam da provjerimo skriptu i korake koji su vam potrebni za konverziju.

Kako pretvoriti CSV u Excel pomoću naredbenog^(Command) retka

Evo koraka za pretvaranje CSV -a u Excel pomoću sučelja naredbenog retka^{(Command Line Interface)} u sustavu Windows 11^{(Windows 11)} ili Windows 10:

1. Otvorite Notepad.
2. Napišite Visual Basic Script (VBS).
3. Spremite VBS datoteku.
4. Otvorite naredbeni redak u mapi.
5. Unesite^(Enter) naredbu za pretvorbu CSV -a u Excel .

Razmotrimo ove korake detaljno!

Prvo otvorite aplikaciju Notepad na računalu sa sustavom Windows 10. Sada morate napisati VBScript sa povezanim naredbama. Ispod^(Below) je cijela skripta koju trebate unijeti u Notepad ; samo kopirajte odavde i zalijepite u svoj Notepad :

'======================================
' Convert CSV to Excel
'
' arg1: source - CSV path\file
' arg2: target - Excel path\file
'======================================

srccsvfile = Wscript.Arguments(0) 
tgtxlsfile = Wscript.Arguments(1)

'Create Spreadsheet
'Look for an existing Excel instance.
On Error Resume Next ' Turn on the error handling flag
Set objExcel = GetObject(,"Excel.Application")
'If not found, create a new instance.
If Err.Number = 429 Then '> 0
Set objExcel = CreateObject("Excel.Application")
End If

objExcel.Visible = false
objExcel.displayalerts=false

'Import CSV into Spreadsheet
Set objWorkbook = objExcel.Workbooks.open(srccsvfile)
Set objWorksheet1 = objWorkbook.Worksheets(1)

'Adjust width of columns
Set objRange = objWorksheet1.UsedRange
objRange.EntireColumn.Autofit()
'This code could be used to AutoFit a select number of columns
'For intColumns = 1 To 17
' objExcel.Columns(intColumns).AutoFit()
'Next

'Make Headings Bold
objExcel.Rows(1).Font.Bold = TRUE

'Freeze header row
With objExcel.ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
objExcel.ActiveWindow.FreezePanes = True

'Add Data Filters to Heading Row
objExcel.Rows(1).AutoFilter

'set header row gray
objExcel.Rows(1).Interior.ColorIndex = 15
'-0.249977111117893

'Save Spreadsheet, 51 = Excel 2007-2010 
objWorksheet1.SaveAs tgtxlsfile, 51

'Release Lock on Spreadsheet
objExcel.Quit()
Set objWorksheet1 = Nothing
Set objWorkbook = Nothing
Set ObjExcel = Nothing

Nakon unosa gornje skripte, trebate spremiti datoteku s nastavkom .vbs . Za to kliknite na File > Save As opciju. U promptu dijaloškog okvira Spremi kao , postavite ^{(Save As)}Spremi kao vrstu^{(Save As Type)} na Sve datoteke^{(All Files)} , a zatim unesite naziv datoteke nakon čega slijedi ekstenzija datoteke .vbs . Nakon toga kliknite na gumb Spremi^(Save) za spremanje VBS datoteke.

Sada idite u mapu u koju ste spremili gornju VBS skriptu i otvorite Command Prompt u ovoj mapi^{(open Command Prompt in this folder)} .

Zatim morate unijeti naredbu sa donjom sintaksom u CMD :

VBSFilename [Input CSV file with path] [Output Excel file with path]

Recimo da ste VBS datoteku nazvali kao "csv-to-excel", tada će vaša naredba izgledati otprilike ovako:

csv-to-excel C:\Users\KOMAL\Desktop\twc.csv C:\Users\KOMAL\Desktop\twc1.xlsx

U slučaju da želite stvoriti Excel datoteku sa starijom ekstenzijom datoteke, npr. XLS , samo zamijenite xlsx s xls . Evo primjera:

csv-to-excel C:\Users\KOMAL\Desktop\twc.csv C:\Users\KOMAL\Desktop\twc1.xls

Zapamtite da morate spomenuti puni put ulaznih CSV i izlaznih Excel datoteka.

Kada unesete gornju naredbu, dobit ćete izlaznu Excel datoteku.

U gornjem VBScript -u postoje opcije za podešavanje širine stupca, zamrzavanje okna, primjenu filtera, podebljanje zaglavlja itd. Možete jednostavno podesiti VBScript kako biste prilagodili ove opcije, a zatim pokrenuti naredbu za pretvaranje CSV -a u Excel putem CMD -a . Ako ste programer, možete dodatno prilagoditi skriptu u skladu s tim.

Dakle, ovako možete pretvoriti CSV u Excel pomoću naredbenog retka^{(Command-Line)} uz pomoć VBScript -a koji je ^(VBScript) kreirao Jeff^{(created by Jeff)} .

Povezano glasi:^{(Related reads:)}

• Kako pretvoriti DBF u Excel u sustavu Windows^{(How to convert DBF to Excel in Windows)}
• How to convert a Text (TXT/CSV) file into an Excel file
• Besplatni paketni softver za pretvaranje PDF u Excel.^{(Free Batch PDF to Excel Converter Software.)}

Convert CSV to Excel (XLS or XLSX) using Command line in Windows

Here is a tutorial to convert CSV to XLS or XLSX using the command-line interface in Windows 11/10. There are multiple ways to convert a CSV file to Excel formats (XLS, XLSX). You can use Microsoft Excel, a dedicated converter freeware, or an online tool to perform the conversion. But, did you know that you can also use Windows command-line interface to convert CVS to Excel? And, you don’t even need any third-party tool for that? If not, this tutorial will be pleasantly surprising for you.

In this article, we are going to show you how you can convert a CSV file to an Excel workbook. For that, we will be using a VBScript. Let us check out the script and steps that you need for conversion.

How to Convert CSV to Excel using Command line

Here are the steps to convert CSV to Excel using Command Line Interface in Windows 11 or Windows 10:

1. Open Notepad.
2. Write a Visual Basic Script (VBS).
3. Save the VBS file.
4. Open Command Prompt in the folder.
5. Enter the CSV to Excel conversion command.

Let’s discuss these steps in detail!

Firstly, open the Notepad application on your Windows 10 PC. You now have to write a VBScript with related commands. Below is the full script that you need to enter in the Notepad; just copy from here and paste it into your Notepad:

'======================================
' Convert CSV to Excel
'
' arg1: source - CSV path\file
' arg2: target - Excel path\file
'======================================

srccsvfile = Wscript.Arguments(0) 
tgtxlsfile = Wscript.Arguments(1)

'Create Spreadsheet
'Look for an existing Excel instance.
On Error Resume Next ' Turn on the error handling flag
Set objExcel = GetObject(,"Excel.Application")
'If not found, create a new instance.
If Err.Number = 429 Then '> 0
Set objExcel = CreateObject("Excel.Application")
End If

objExcel.Visible = false
objExcel.displayalerts=false

'Import CSV into Spreadsheet
Set objWorkbook = objExcel.Workbooks.open(srccsvfile)
Set objWorksheet1 = objWorkbook.Worksheets(1)

'Adjust width of columns
Set objRange = objWorksheet1.UsedRange
objRange.EntireColumn.Autofit()
'This code could be used to AutoFit a select number of columns
'For intColumns = 1 To 17
' objExcel.Columns(intColumns).AutoFit()
'Next

'Make Headings Bold
objExcel.Rows(1).Font.Bold = TRUE

'Freeze header row
With objExcel.ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
objExcel.ActiveWindow.FreezePanes = True

'Add Data Filters to Heading Row
objExcel.Rows(1).AutoFilter

'set header row gray
objExcel.Rows(1).Interior.ColorIndex = 15
'-0.249977111117893

'Save Spreadsheet, 51 = Excel 2007-2010 
objWorksheet1.SaveAs tgtxlsfile, 51

'Release Lock on Spreadsheet
objExcel.Quit()
Set objWorksheet1 = Nothing
Set objWorkbook = Nothing
Set ObjExcel = Nothing

After entering the above script, you need to save the file with the .vbs file extension. For that, click on the File > Save As option. In the Save As dialog prompt, set Save As Type to All Files and then enter the filename followed by the .vbs file extension. After that, click on the Save button to save the VBS file.

Now, go to the folder where you have saved the above VBS script and open Command Prompt in this folder.

Next, you have to enter a command with the below syntax in CMD:

VBSFilename [Input CSV file with path] [Output Excel file with path]

Let’s say you have named the VBS file as “csv-to-excel”, then your command will look something like the below one:

csv-to-excel C:\Users\KOMAL\Desktop\twc.csv C:\Users\KOMAL\Desktop\twc1.xlsx

In case you want to create an Excel file with the older file extension i.e., XLS, just replace xlsx with xls. Here is an example:

csv-to-excel C:\Users\KOMAL\Desktop\twc.csv C:\Users\KOMAL\Desktop\twc1.xls

Do remember that you have to mention the full path of both input CSV and output Excel files.

As you enter the above command, you will get the output Excel file.

In the above VBScript, there are options to adjust column width, freeze pane, apply filter, make header bold, etc. You can easily tweak the VBScript to customize these options and then run the command to convert CSV to Excel through CMD. If you are a programmer, you can further customize the script accordingly.

So, this is how you can convert CSV to Excel using Command-Line with help of a VBScript created by Jeff.

Related reads:

• How to convert DBF to Excel in Windows
• How to convert a Text (TXT/CSV) file into an Excel file
• Free Batch PDF to Excel Converter Software.

Related posts

• Popis naredbi DISKPART i kako ih koristiti u sustavu Windows 11/10

• Kako promijeniti veličinu videa pomoću naredbenog retka s FFmpeg u sustavu Windows 10

• Kako prikazati naredbeni redak u Upravitelju zadataka sustava Windows 11/10

• Kako koristiti naredbe FINDSTR i Select-String u sustavu Windows 11/10

• Pristupite FTP poslužitelju pomoću naredbenog retka u sustavu Windows 10

• Popravite pogrešku Excel stdole32.tlb u sustavu Windows 10

• Kako pokrenuti naredbeni redak kao administrator u sustavu Windows 11/10

• Preuzmite PDF Vodič za Windows Command Reference od Microsofta

• Naredba ForFiles omogućuje vam upravljanje datotekama i mapama na dijeljenoj mreži

• Kako umetnuti CSV ili TSV u Excel radni list

• Kako uključiti automatsko dovršavanje u naredbenom retku sustava Windows

• 4 načina za pretvaranje Excela u Google tablice

• Kako urediti registar iz naredbenog retka u sustavu Windows 10

• Opcije naredbenog retka ChkDsk, prekidači, parametri u sustavu Windows 11/10

• Pretvorite Word, PowerPoint, Excel dokumente u PDF pomoću Google dokumenata

• Kako otvoriti Apple Numbers datoteku u Excelu na Windows računalu

• Kako ispisati sve Windows usluge pomoću PowerShell-a ili naredbenog retka

• Osnovni savjeti za naredbeni redak za Windows 11/10

• Kako pretvoriti DBF u Excel (XLSX ili XLS) u sustavu Windows 10

• Kako koristiti naredbeni redak za ubijanje programa