[dba-Tech] FireFox

[Gustav Brock]

Hi Stuart

Very clever, though I've never had the need to rename sheets in an automated way.

/gustav

-----Oprindelig meddelelse-----
Fra: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] På vegne af Stuart McLachlan
Sendt: 28. oktober 2016 02:35
Til: Discussion of Hardware and Software issues <dba-tech at databaseadvisors.com>
Emne: Re: [dba-Tech] FireFox

You don't even need to change the extention.  Many ZIP file utilities let you open regardless of the extension.  ( I just right click on a .xlsx file and select 7Zip - Open from my explorer
menu.)

I've done this occassionally.  If you need to check the number of sheets and the sheet names (and possibly rename sheets) in a load of workbooks, the simplest way is to open the  
archive  7Zip and edit the file Workbook.xml.     

It's fairly simple to write a small utility to do this this sort of thing for all the files in a directory.
:)


On 27 Oct 2016 at 17:34, Jim Lawrence wrote:

> Hi Lambert:
> 
> I did not know that. I could visualize some interesting applications.
> Have you ever used this knowledge?
> 
> Jim
> 
> ----- Original Message -----
> From: "Heenan, Lambert" <Lambert.Heenan at aig.com>
> To: "Discussion of Hardware and Software issues"
> <dba-tech at databaseadvisors.com> Sent: Thursday, October 27, 2016
> 10:39:05 AM Subject: Re: [dba-Tech] FireFox
> 
> On a related note. Did you know that Excel 2007+ files are actually 
> ZIP files containing a series of XLM files. That's why they do not 
> compress much: already compressed internally. Change the extension of 
> an .xlsx file to ZIP and you can open it in your favorite ZIP manager 
> as see the structure laid out.
> 
> Lambert