how to access or export the names that defined in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

as the title of question, I would like to export some properties of excel
such as font size ,sheet name and so on into a table of database, especially
the names defined in excel , which can respective a cell value or a cell .
any helpl will be veryvery appriciated!
 
as the title of question, I would like to export some properties of excel
such as font size ,sheet name and so on into a table of database, especially
the names defined in excel , which can respective a cell value or a cell .
any helpl will be veryvery appriciated!
Click to expand...

Most of this can be accomplished by adding the excel object library
11.0/12.0 reference to your project, and using it's members. Or if you
want you could save the excel doc as an XML file (it's listed as a
type on the Save As dialog) and then parse that xml file to get the
values. If you use the first method be sure you properly release the
references to excel so you don't end up with a memory leak in your
app. The second option is nice if you can use it, as you don't need to
worry about COM, and I don't think you even need excel on the computer
that does the parsing.

Perhaps if we knew why you doing this we could offer more insight?

Thanks,

Seth Rowe
 
Back
Top