SQL Excel SQL Excel - Freeware Excel Add-In - simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Microsoft Access etc

Note on New Setting File - sql_excel_settings.xml Print E-mail
Sunday, 15 March 2009

Here is quick note on the new settings file which is being used to store some of the settings for the addin.

The files name is sql_excel_settings.xml

The file is stored on an XP machine in the following location:

C:\Documents and Settings\[USERNAME]\Application Data\sqlexcel

On a vista machine it is in the equivalent location (slightly different to the above)

One thing to note about this file is that it is recommened to change the file by using the options section of the "About" button (the coffe cup button on the toolbar).  Changing it is ok directly in the xml file but you should be careful not to break any of the tags.  If you did happen to play around with the file and mess it up a bit, you could always copy in a basic verion of the file that is shown below (this is the file for Version 1.4 of the addin).

<?xml version="1.0" encoding="UTF-8"?>
<application_settings>
 <PasteOptions>
  <ExcelPasteFormatting>
   <value>Grey and White</value>
  </ExcelPasteFormatting>
  <ExcelPasteDestination>
   <value>Active Cell</value>
  </ExcelPasteDestination>
  <ExcelPasteHeaders>
   <value>1</value>
  </ExcelPasteHeaders>
  <ExcelPasteAutoFilter>
   <value>1</value>
  </ExcelPasteAutoFilter>
 </PasteOptions>
 <FileSettings>
  <QueryFilesPath>
   <value>C:\SomePath</value></QueryFilesPath>
 </FileSettings>
</application_settings>

Last Updated ( Sunday, 15 March 2009 )
 
Next >

Google Translate

SQL Excel Add-in |Copyright SQL Excel, 2007-2009|Website Pricer|balloon boy |Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation