[Windows Bash Script] convert csv to html table

Posted on 2017 年 10 月 18 日 by cowman.chiang

source: How to find and replace a string in text file using batch file

just replace “,” with html table tag.

@echo off
setlocal enabledelayedexpansion
set txtfile=%~1
set newfile=Output.html
if exist "%newfile%" del /f /q "%newfile%"
echo ^<table border='1'^> >> %newfile%
for /f "tokens=*" %%a in (%txtfile%) do (
   set newline=%%a
   set newline=^<tr^>^<td^>!newline:,=^</td^>^<td^>!^</td^>^</tr^>
   echo !newline! >> %newfile%
)
echo ^</table^> >> %newfile%

@echo off

setlocal enabledelayedexpansion

set txtfile=%~1

set newfile=Output.html

if exist "%newfile%" del /f /q "%newfile%"

echo ^<table border='1'^> >> %newfile%

for /f "tokens=*" %%a in (%txtfile%) do (

set newline=%%a

set newline=^<tr^>^<td^>!newline:,=^</td^>^<td^>!^</td^>^</tr^>

echo !newline! >> %newfile%

)

echo ^</table^> >> %newfile%

This entry was posted in Windows Bash Script. Bookmark the permalink.

One Response to [Windows Bash Script] convert csv to html table

cowman.chiang says:

2017 年 10 月 18 日 at 16:59:38

use vba in excel : http://analystcave.com/excel-export-excel-to-html-convert-tables-html/

Comments are closed.

[Windows Bash Script] convert csv to html table

One Response to [Windows Bash Script] convert csv to html table

Categories