Read the data of CSV file inside Zip File without

问题:

I have number of Zip Files {'File1.zip', 'File2.zip', 'File3.zip',..., 'FileN.zip'} in which each zip file contains a Data.csv file. I want to read the data in 'Data.csv' of each Zip file without having to extract the Zip files' contents. Is this possible..?

回答1:

Certainly Winzip / 7zip / Winrar do not have COM interface component which can invoke directly unlike word, excel an other application.

Hence @Java is appropriate

Idea is don't extract files physically , however create absolute path of file such that windows consider as physical presence of File (similar to ~tmp file)

here the code

zipFilename = 'Ex.zip';
zipJavaFile  = java.io.File(zipFilename);

% Create a Java ZipFile

 zipFile = org.apache.tools.zip.ZipFile(zipJavaFile);

% Extract the entries from the ZipFile.

 entries = zipFile.getEntries;
 cnt = 1;

% Get Zip File Paths

 while entries.hasNext
   tempObj = entries.nextElement;
   file{cnt,1} = tempObj.getName.toCharArray';
   cnt = cnt+ 1;
 end

% Extract File Name

 ind = regexp(file,'$*.csv$');
 ind = find(~cellfun(@isempty,ind));  % Find Non Empty Cell Index
 file = file(ind);

% Create Absolute Path so that Windows consider as Directory

  file = cellfun(@(x) fullfile('.',x),file,'UniformOutput',false);

% Now Operate Any thing on File.