tiff to excel

March 11, 2009 at 10:11:35
Specs: Windows XP
Hello

I'm having a problem which is i have a lot of .Tiff files and i need to read there names and import them into excel file. In other words, i'm trying to sort all the Tiff files and import their names into excel.
can anyone help me please ASAP

Thank You,


See More: tiff to excel

Report •


#1
March 11, 2009 at 16:00:57
Here's a little BAT file that you can use to get the info into a txt file, then import the txt file into excel.

It will get you the name, file size and date and put it in a file called "spreadsheet.txt"

IMPORTANT. You must run in from within the target Dir.

What ever info you don't need you can delete in Excel.

------------------------------------------
@ECHO OFF
REM
REM MUST BE RUN FROM WITHIN THE TARGET DIR
REM
REM This will get the following information:
REM The File Name
REM The File Size
REM The File Date
REM Today’s Date
REM Gives the user the option of getting the information FOR ALL files or
REM only those created today.
REM Change the file extension .tiff to suit your needs.
REM
REM MUST BE RUN FROM WITHIN THE TARGET DIR
REM

ECHO File Size File Name > spreadsheet.txt
ECHO ==================== >> spreadsheet.txt
ECHO. >> spreadsheet.txt

:LOOP
SET /P ANS=Get ONLY Files Created TODAY? Y-N-Q:

IF "%ANS%"=="" (
ECHO.
ECHO Please Enter [Y]es or [N]o or [Q]uit.
ECHO.
GOTO :LOOP
)
IF /I "%ANS%"=="Y" (
GOTO :TODAYONLY
) ELSE (
IF /I "%ANS%"=="N" (
GOTO :GETALL
) ELSE (
GOTO :QUIT
)
)

:TODAYONLY
FOR /f "tokens=2" %%t in ( "%DATE%" ) do (
FOR /f "tokens=*" %%i in ('dir /b *.tiff') do (
FOR /f "tokens=1" %%j in ("%%~zi") do (
FOR /f "tokens=1" %%k in ("%%~ti") do (
IF %%k==%%t (
ECHO %%j %%i >> spreadsheet.txt ) ) ) ) )
GOTO:EOF

:GETALL
FOR /f "tokens=*" %%i in ('dir /b *.tiff') do (
FOR /f "tokens=1" %%j in ("%%~zni") do (
ECHO %%j %%i >> spreadsheet.txt ) )
GOTO:EOF

:QUIT
DEL spreadsheet.txt
GOTO:EOF

MIKE


Report •
Related Solutions


Ask Question