Getrangebyname


#1

Hi Laurence,

I have a question with getRangeByName when I was developing a report for our customers. How to find the cell if more than 1 worksheet have the same cell name.

For example;

one workbook has 2 worksheet, and both worksheet have “test” as cell A1’s name. How do I find this A1 cell corresponding to <span style=“font-size: 10pt; font-family: “MS Sans Serif”;”>particular worksheet?

I tried my example
excel.Worksheets.GetRangeByName(“test”)(0, 0).PutValue(“me1”)
excel.Save(“C:\test.xls”)
System.Diagnostics.Process.Start(“c:\test.xls”)

The second worksheet has “me1” at A1, and the first worksheet has “gHgtbburp”


#2

Could you please upload your file here?

MS Excel cannot set one name to two ranges. So I think cell A1’s name in your first worksheet is “Sheet1!test” and the second is “test”. You can verify it by “Insert->Name->Define”.

So please try:

excel.Worksheets.GetRangeByName(“Sheet1!test”)(0, 0).PutValue(“me1”)

excel.Worksheets.GetRangeByName(“test”)(0, 0).PutValue(“me1”)
excel.Save(“C:\test.xls”)
System.Diagnostics.Process.Start(“c:\test.xls”)


By the way, “gHgtbburp” is a license warning. Please check http://www.aspose.com/wiki/default.aspx/Aspose.Excel/GarbageTextInWorksheet.html
for reference.
You can put some value at Cell H20 to move the random string out of cell A1.