[dba-Tech] FireFox

[Stuart McLachlan]

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  
> 
> -----Original Message-----
> From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On
> Behalf Of Jim Lawrence Sent: Thursday, October 27, 2016 1:18 PM To:
> Discussion of Hardware and Software issues Subject: [dba-Tech] FireFox
> 
> Hi All:
> 
> Does everyone already know this or is it just me, that the following
> amazing? 
> 
> I have just discovered that FireFox is built on top of a series of
> SQLite files. Every plugin, setting, history, download, cookie, visted
> site, caches and bookmarks are all stored in these database files. All
> tranaction date, size, duration, activity and location is stored in
> the records. If you lose some information and wish to trace it just
> dig through these files. Mind you, if you have been using your version
> of FF for more than a couple weeks, the files are huge and date ranges
> are the only way to find anything usable (50 pages of data is
> useless)...spent hours last night trying to find details on a couple
> of visited site (and was learning how SQLite works).
> 
> I have not tried to use other SQLs to access the data as I suspect
> SQLite has it own data encoding. I was working at the command prompt
> for quite a while before I downloaded a GUI. Has anyone else had
> experience with SQLite? If you have do you have any comments or
> recommendations?
> 
> TIA
> Jim    
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com