topic Re: Closing csv file after reloading in QlikView

Closing csv file after reloading

Mon, 04 Mar 2013 04:49:00 GMT

Hiii,

i am fetching the data from csv file that is reloaded every day. but while overwriting new data in place of old data from .net side it give an error that file is still open.

So is there any way to close that csv file after taking the data in qlikview. so that on nxt day the overwriting in csv is done without any problem.

Re: Closing csv file after reloading

Mon, 04 Mar 2013 05:04:42 GMT

Hi,

Try with killing that process ..

taskkill /F /IM "excel.exe" /T

Karthik

Re: Closing csv file after reloading

Mon, 04 Mar 2013 05:13:30 GMT

do i have to mention the file name with its path in place of excel.exe

Re: Closing csv file after reloading

Mon, 04 Mar 2013 05:26:08 GMT

You can't kill process by file name..

It will close all excel files.. If you wants to kill particularly that file then its won't work.

Re: Closing csv file after reloading

Mon, 04 Mar 2013 09:27:28 GMT

Hi You can use Windowtitle switch to kill the file, after ""windowtitle eq" specify the exact window title. hope this helps you.

tasklist /fi "windowtitle eq Test.txt - Notepad"