MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Microsoft Excel

with 5 comments

This links to my blog posts and pages dealing with using Microsoft Excel 2007 and 2008, including Visual Basic for Applications. The blog pages show below the top-level page in the right hand column, while blog posts only show in the list below.

Functions in Excel:

Querying external database sources:

Tricks and Techniques in Excel:

If you have suggestions for other concepts, post a comment.

Written by maclochlainn

November 14th, 2008 at 12:03 am

Posted in Uncategorized

5 Responses to 'Microsoft Excel'

Subscribe to comments with RSS or TrackBack to 'Microsoft Excel'.

  1. I heard about a not too bad program that works with Microsoft Excel files, it’s called Recovery Toolbox for Excel. It is free utility to save important information, such as graphics, statistic and mathematics. The program will help you to recover valuable information and avoid its losses, tool scans your broken worksheet, and then gets the data from this document. It will help you to repair damaged files in Microsoft Excel sheet recognizable format, and repair file Excel this file is not in a recognizable format.

    mutu26

    17 Feb 09 at 10:28 am

  2. I took a quick look at the web site allowing the comment but I changed the link to the home page for a set of tools. I’ve never tried them and can’t vouch for them. The fact that the tool for Excel was an *.EXE not an *.MSI made me a bit nervous. If somebody else checks it out, please let us know whether it’s a good thing or not. I’ll try to setup a contained test environment after March 2009. Thanks.

    maclochlainn

    17 Feb 09 at 12:40 pm

  3. Hi ,

    I have requirement so as to export the data from PL/SQL to Microsoft excel.

    While exporting these data i need to change the worksheet name to one that i am passing ,lets say data_dd/mm/yy should be the name of worksheet.

    Can you please help me out in sorting this out

    Thanks very much in advance

    Swapnil

    27 Jun 12 at 6:45 am

  4. This blog post shows you how to create an Excel spreadsheet from PL/SQL. Hope it helps you solve the problem.

    maclochlainn

    27 Jun 12 at 8:31 am

  5. Hi,

    Thanks very much for quick reply. The link helped me lot.

    But one question still to ask is that how can i name worksheet in excel with particular value passed from PL/SQL.

    for example,

    If i pass string “01/01/2012_emp_data”
    from pl/sql worksheet in EXCEL should be renamed
    to “01/01/2012_emp_data”

    swapnil

    27 Jun 12 at 12:13 pm

Leave a Reply