Hi,
I got a problem with assigning a unique key value to an excel file. (custom properties of a file?)
does anybody know how to do it?
I cannot rely on the file name, that's why I need something unique to identify the file no matter what file name is.
File will be copied over and over, file name will be changed, but the unique key should be the same.
Thanks in advance.
how to assign a unique value to an excel file?
Moderator: General Moderators
-
almightyad
- Forum Newbie
- Posts: 2
- Joined: Wed Jun 13, 2007 10:45 pm
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: how to assign a unique value to an excel file?
So what exactly is the problem?almightyad wrote:I got a problem with assigning a unique key value to an excel file. (custom properties of a file?)
does anybody know how to do it?
You open/create the original Excel file, set the property and save it.
Where's the difficulty?
-
almightyad
- Forum Newbie
- Posts: 2
- Joined: Wed Jun 13, 2007 10:45 pm
Re: how to assign a unique value to an excel file?
The problem is how to write a data into a particular row/column.
Writing data to an empty file is easy, like generating report.
my problem is I don't know how to write data to a particular row / column .
thanks
Writing data to an empty file is easy, like generating report.
my problem is I don't know how to write data to a particular row / column .
thanks
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: how to assign a unique value to an excel file?
Well start by considering writing a "real" Excel file.almightyad wrote:The problem is how to write a data into a particular row/column.
I don't know what you're doing now, but a comma-separated or an HTML file with an extension of .xls isn't an Excel file. Using the library listed in my signature, you can read, edit and write real Excel (xls or xlsx) files, with formatting, properties, formulae, and many of the other features of Excel itself.
This includes the ability to set the values of individual cells within the worksheets, or to change the properties such as title/subject/author/company/etc that appear when you do File/Properties from within MS Excel.