tags:

views:

5

answers:

0
Q: 

Getting relative addresses in Excel Interop

In C# programs using the Excel Interop library,

the Range.get_Address(...) method seems to return a relative address only if R1C1 format is specified. Does the library provide a simple way to get relative A1-style addresses?

related questions

How do I find which cells are selected on an Excel worksheet?
Prevent "Formulas have been recalculated, save" dialog?
How to release excel process?
Windows Forms above Excel
Adding buttons to spreadsheets in .NET (VSTO)
Comparing Ranges in Excel
How do I auto size columns through the Excel interop objects?
UDF in VSTO without creating a separate project
Display page numbers in a excel sheet generated using C#.NET
COMException (0x80010108 - RPC_E_DISCONNECTED) When Closing Excel.Workbook
Microsoft Office Interop Excel 12.0 not working in IIS 7
Load an assembly dynamically and create an variable of its type
C# Excel - Manage column properties.
Which Excel Interop objects to clean up myself and which to clean up by GC.Collect()
How can I access the values from `Series.Values` (Excel Chart)
Are we unable to use Interop objects in generic objects in .NET 4.0?
Use Excel Interop to grab image of Excel chart without writing to disk or using the clipboard
How to write excel by opening it programmatically with Microsoft.Office.Interop.Excel dll ?
How can I Create an Excel Sheet with Microsoft.Office.Interop.Excel.dll?
Why is .NET Sql Server access faster than Excel Interop?
Excel Interop: Application and ApplicationClass differences
C# and Excel Interop issue, Saving the excel file not smooth
Create UDF using VSTO and no VBA
Workaround to see if Excel is in cell-edit mode in .NET