Hi
How to read the content of merged cells, using C#
thx
Yuelin
how to read merged cells?
Hot Topic
- my buddy
- What's your experience with the buddy program?
- Calendar control issue in excel
- VBA in EXCEL - Connect to SQL Server
- I need help figuring out what is crashing my VBA for Access 2003
- What's your experience with the buddy program?
- How to check the TCP/IP checkbox in network connection property window?
- Linking to an Oracle DB via MSAccess/VBA
- Run SQL Server 2005 DTS Package from MS Access
- Fastest Processor for Running Excel VBA Macros
Microsoft ISV
- VBA Excel Module opening Access DB with Recordset
- VB Postgres connection problem
- Problems with Project Server
- Microsoft Access Runtime/Developer (XP) - compatibility issue with XP SP2?
- VBA Mail Merge Question
- Live Communications Server 2005 SP1 - no login accepted from MSN 5.1
- Increase Speed of a Word Macro
- VBA for Powerpoint
- app_sheetbeforedoubleclick exists?
- Problem in CDO.iMailBox
how to read merged cells?
mwong7025
Hi Yuelin,
Here's some sample code from our support engineer:
We can easily access the data from merged cell like a normal cell.
If A1 and B1 are merged, we can access the data from Cells[1, 1].
====
Excel.Worksheet ws;
ws = (Excel.Worksheet)thisWorkbook.Worksheets[1];
Excel.Range cf;
cf = (Excel.Range)ws.Cells[1,1];
MessageBox.Show((string)cf.Text);
====
-brenda (ISV Buddy Team)