Page 1 of 1

how to assign a unique value to an excel file?

Posted: Tue Jun 09, 2009 9:48 pm
by almightyad
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.

Re: how to assign a unique value to an excel file?

Posted: Wed Jun 10, 2009 2:47 am
by Mark Baker
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?
So what exactly is the problem?

You open/create the original Excel file, set the property and save it.
Where's the difficulty?

Re: how to assign a unique value to an excel file?

Posted: Wed Jun 10, 2009 11:46 pm
by almightyad
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

Re: how to assign a unique value to an excel file?

Posted: Thu Jun 11, 2009 2:54 am
by Mark Baker
almightyad wrote:The problem is how to write a data into a particular row/column.
Well start by considering writing a "real" Excel file.

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.