Berikut adalah tutorial untuk mengonversi CSV ke XLS atau XLSX menggunakan antarmuka ^(interface)baris^{(convert CSV to XLS or XLSX using the command-line)} perintah di Windows 11/10 . Ada beberapa cara untuk mengonversi file CSV ke format Excel ( XLS , XLSX ). Anda dapat menggunakan Microsoft Excel , freeware konverter khusus, atau alat online untuk melakukan konversi. Namun, tahukah Anda bahwa Anda juga dapat menggunakan antarmuka baris perintah Windows untuk mengonversi ^(Windows)CVS ke Excel ? Dan, Anda bahkan tidak memerlukan alat pihak ketiga untuk itu? Jika tidak, tutorial ini akan sangat mengejutkan Anda.

Pada artikel ini, kami akan menunjukkan kepada Anda bagaimana Anda dapat mengonversi file CSV ke buku kerja Excel . Untuk itu, kita akan menggunakan VBScript . Mari kita periksa skrip dan langkah-langkah yang Anda butuhkan untuk konversi.

Cara Mengonversi CSV ke Excel menggunakan Command line

Berikut langkah-langkah untuk mengkonversi CSV ke Excel menggunakan Command Line Interface di Windows 11 atau Windows 10:

1. Buka Notepad.
2. Buatlah sebuah Visual Basic Script (VBS).
3. Simpan file VBS.
4. Buka Command Prompt di folder.
5. Masukkan^(Enter) perintah konversi CSV ke Excel .

Mari kita bahas langkah-langkah ini secara detail!

Pertama, buka aplikasi Notepad di PC Windows 10 Anda. Anda sekarang harus menulis VBScript dengan perintah terkait. Di bawah^(Below) ini adalah skrip lengkap yang harus Anda masukkan di Notepad ; cukup salin dari sini dan tempel ke Notepad Anda :

'======================================
' 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

Setelah memasukkan skrip di atas, Anda perlu menyimpan file dengan ekstensi file .vbs . Untuk itu, klik opsi File > Save As . Pada prompt dialog Save As , atur ^{(Save As)}Save As Type ke All Files lalu masukkan nama file diikuti dengan ekstensi file .vbs . Setelah itu, klik tombol Save untuk menyimpan file VBS .

Sekarang, buka folder tempat Anda menyimpan skrip VBS di atas dan ^(VBS)buka Command Prompt di folder ini^{(open Command Prompt in this folder)} .

Selanjutnya, Anda harus memasukkan perintah dengan sintaks di bawah ini di CMD :

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

Katakanlah Anda telah menamai file VBS sebagai "csv-to-excel", maka perintah Anda akan terlihat seperti di bawah ini:

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

Jika Anda ingin membuat file Excel dengan ekstensi file lama yaitu XLS , ganti saja xlsx dengan xls . Berikut ini contohnya:

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

Ingatlah bahwa Anda harus menyebutkan path lengkap dari file CSV input dan output Excel .

Saat Anda memasukkan perintah di atas, Anda akan mendapatkan file Excel keluaran .

Dalam VBScript di atas , ada opsi untuk menyesuaikan lebar kolom, membekukan panel, menerapkan filter, membuat header tebal, dll. Anda dapat dengan mudah mengubah VBScript untuk menyesuaikan opsi ini dan kemudian menjalankan perintah untuk mengonversi CSV ke Excel melalui CMD . Jika Anda seorang programmer, Anda dapat menyesuaikan skrip lebih lanjut.

Jadi, ini adalah bagaimana Anda dapat mengonversi CSV ke Excel menggunakan Command-Line dengan bantuan VBScript yang ^(VBScript) dibuat oleh Jeff^{(created by Jeff)} .

Bacaan terkait:^{(Related reads:)}

• Bagaimana mengkonversi DBF ke Excel di Windows^{(How to convert DBF to Excel in Windows)}
• How to convert a Text (TXT/CSV) file into an Excel file
• Perangkat Lunak Konverter PDF ke Excel Batch Gratis.^{(Free Batch PDF to Excel Converter Software.)}

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

Here is a tutorial tо 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

• Daftar DISKPART Perintah dan Cara Menggunakannya di Windows 11/10

• Cara Resize Video menggunakan Command-line dengan FFmpeg di Windows 10

• Cara Menampilkan Command Line di dalam Task Manager dari Windows 11/10

• Cara Menggunakan FINDSTR and Select-String Commands di Windows 11/10

• Access FTP Server menggunakan Command Prompt di Windows 10

• Cara Membekukan Baris dan Kolom di Excel

• Convert CSV ke GPX or KML menggunakan alat Converter gratis di Windows 11/10

• Cara Menghapus Instalasi Program Menggunakan Command Prompt di Windows 10

• Cara Menggunakan Baris Perintah untuk Membunuh Program

• Best Free Batch PDF ke Excel Converter software untuk Windows 10

• Cara membuka file TSV pada PC Windows 10

• Cara mengedit registri dari Command Prompt di Windows 10

• 5 Cara Mengonversi Teks ke Angka Di Excel

• Cara membandingkan dua Files untuk perubahan menggunakan Command Prompt

• Perbaiki Kesalahan stdole32.tlb Excel di Windows 10

• Cara menghapus nilai dari sel tetapi menyimpan rumus Anda, di Microsoft Excel

• Cara Membuat Tournament Bracket di Windows 11/10

• Daftar CMD or Command Prompt keyboard shortcuts di Windows 11/10

• Konversi Gambar Antar Format melalui Command Line di Ubuntu

• Convert Word, PowerPoint, Excel Documents ke PDF menggunakan Google Docs