How can i read merged cells from an excel sheet using vb.net?
604748
In a set of merged cells the content is stored in the first cell. e.g. if you have a merged cell covering the range of A1 to C3 with the word "title" in it then you only need to link to cell A1 to return "title".
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
242526
I don't have a real answer for you.\n\nBut you can either use formulas in each cell, or apply Visual Basic Macros. I have done a lot of VBA, but only with Word. VBA is pretty easy - except you need to know the names of the various objects. But sample macros are floating around and Microsoft is fairly good about having details on this sort of thing.\n\nIn fact, now that I think of it, you might be better off writing the whole thing in Visual Basic and skip Excel. (Which, of course, does you no good if you don't have VB.)
986040
If you are talknig about the VBA of Excel, then\nYes\nThere is a way\nI answered this one 2 days ago\n\nIt is by using the object "WorksheetFunction"\nType\nWorksheetfunction.\nin your code and, you will see the list of available functions that you can use from VBA in XL.\nThis list will not have some big functions like OFFSET, or ADDRESS\nany way\nAbout the other solution (Putting function in your worksheet), actually, you can do the function in another worksheet and link the result to the one that you need.\nThis technique is better, just to allow your user to see what function you used for this result\n\nMail me if you need more info\n\nEnjoy my profile, I am the VBAXLMan
930016
Right click on that cell and go to Format Cells.  Now, go to the Alignment tab and check the box that says "Wrap Text"
55468
your function would be =CONCATENATE("""", <field>, """")\n\nif you want the data to be in the same fields, you may need to use multiple sheets.
216138
this method you can cc to the sheet(s) you select on the same cell of each worksheet.\nhold ctrl and click all sheet tabs at lower left corner that you want to mirror the data, click the input sheet first, go to the cell and make entry, say A1, when done, doubleclick the other sheet tabs, will get you back to single sheet entry.
459913
Excel has that limitation.\n\nLook into using MS Access instead.
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
1118432
Scroll until you get just the header rows at the top of the sheet (they should be there anyhow). Drag the little bar just above the top arrow on the vertical scroll bar for the workbook, down to below the header rows (the "splitter"). You should now see the header rows, then a thin divider line (the splitter bar) and the rest of your document below that. Now, go to the Window menu and select 'Freeze panes'. Voila!\n\nTo undo this, just go Window->Unfreeze panes.
588082
If your data is spread across many sheets, but the layout of the sheets is the same (i.e. the columns and formatting are all identical), and you want to get all the data on to one sheet, then just copy and paste it together on to one sheet.\n\nWithout knowing more details, there is no quick way to avoid just doing it by hand.
1032873
Hi Ally, \n\nThe quick and simplest way to do this if this is a one-time thing is to do it manually:\n1. Copy the data from the other file by just highlighting the data and hitting ctrl+c or whatever the key stroke to copy text in the other file's program is.\n2. Paste that in a new excel spreadsheet. \n3. From the new excel spreadsheet, copy and paste the appropriate cell from/to the template.\n\nIf you can not copy the other file's data, then you can try to export the other file into a file (a comma delimited file) and use Excel to open that file. Then perform step 3.\n\nIf this is going to happen frequently, then for number 3, instead of doing it manually, you can write a macro to do it for you. Excel macro's can only operate on Excel spreadsheets.\n\nNow, if your question was really how to write an excel macro, I then refer you to this link for reference:\nhttp://www.excel-vba.com/macros/index.htm\n\nA good book on excel macros is:\nhttp://www.oreilly.com/catalog/exlmacro/\n\n\nHope that helps.
817438
1. Select the cells you want to include in  a range.\n2. Click on the name box.\n3. Type the name for the range.\nthat's it.\n\nClicking the drop down button on the name box will list all the range names that has been created.
1185281
Goto Tools Menu > Macro > Visual Basic Editor (Alt + F11)\n\nType this in exactly...\n\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)\n    Sheet1.Cells(1, 1) = Sheet1.Name\nEnd Sub\n\nSheet1.Cells(Row, Column)\nRow = Row Number\nColumn = Column Number (A = 1, B = 2, C = 3, etc)\n\nThis will change the text in the cell everytime you change the name of the sheet and click anywhere in the sheet.
497310
After draggin the file into Excel, your database will take only one column.\nSelect that column and go to Data > Text to columns to start the wizard you need to convert it.\n\nXLMan
1154342
Assuming you are using VB6 and your data is in Columns with headings on top you can do the following.\n\nPlace a Data component on your form. Its normally  the second last component in your tool box. Then place 4 text boxes on your form.\n\nclick on your Data component and change the properties as follows.\nConnect =>set to Excel 5.0 \nDataBaseName => (Brows to the excel file that has the data)\nRecordSet => Specify the page in excel eg. Sheet1\n\nNow click on each text box one at at time and change the values as follows.\nDataSource => Data1 or whatever you called your Data component\nDataField =>Select the heading for the column you want to view. Select a different one for each text box, X values and Y values\n\nNow Run your project \nBy clicking the forward and reverse buttons you can scroll through your data. Read the help menus to write the rest of your program.\n\nI hope this helps\nGood luck.
347199
If your speaking of the Formula Expert, this wasn't in the Crystal Reports that came with VS.Net 2003.\nYou have to use the Formula Editor.