How to get a range from merged cell in excel
I received this excel file from user. It seems was created without any standard pattern. I don't have any idea for getting holidays from this excel.
How to iterate in each month?
I tried use Excel.Worksheet.Range.Find("January") for getting first cell for start finding in each month.
Dim currentFind As Excel.Range = Nothing
Dim firstFind As Excel.Range = Nothing
currentFind = objWs.Range("A1:AM100").Find("January", , _
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)
But it return cell at "A4" (ROW: 4 , COLUMN: 1) because Title Month cell was merged. I can not use this cell for initial iterating and access to all date in this month. How to know a range between A4 was merged?
c# excel vb.net
asked Nov 12 at 11:49
Fame th
389724
add a comment |
I received this excel file from user. It seems was created without any standard pattern. I don't have any idea for getting holidays from this excel.
How to iterate in each month?
I tried use Excel.Worksheet.Range.Find("January") for getting first cell for start finding in each month.
Dim currentFind As Excel.Range = Nothing
Dim firstFind As Excel.Range = Nothing
currentFind = objWs.Range("A1:AM100").Find("January", , _
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)
But it return cell at "A4" (ROW: 4 , COLUMN: 1) because Title Month cell was merged. I can not use this cell for initial iterating and access to all date in this month. How to know a range between A4 was merged?
c# excel vb.net
asked Nov 12 at 11:49
Fame th
389724
Possible duplicate of VB.net excel merged cells range
– rosi97
Nov 12 at 12:09
Take a look atMergeCellsproperty i.e. you can use:If currentFind.Mergecells Then...
– shrivallabha.redij
Nov 12 at 13:16
add a comment |
I received this excel file from user. It seems was created without any standard pattern. I don't have any idea for getting holidays from this excel.
How to iterate in each month?
I tried use Excel.Worksheet.Range.Find("January") for getting first cell for start finding in each month.
Dim currentFind As Excel.Range = Nothing
Dim firstFind As Excel.Range = Nothing
currentFind = objWs.Range("A1:AM100").Find("January", , _
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)
But it return cell at "A4" (ROW: 4 , COLUMN: 1) because Title Month cell was merged. I can not use this cell for initial iterating and access to all date in this month. How to know a range between A4 was merged?
c# excel vb.net
asked Nov 12 at 11:49
Fame th
389724
I received this excel file from user. It seems was created without any standard pattern. I don't have any idea for getting holidays from this excel.
How to iterate in each month?
I tried use Excel.Worksheet.Range.Find("January") for getting first cell for start finding in each month.
Dim currentFind As Excel.Range = Nothing
Dim firstFind As Excel.Range = Nothing
currentFind = objWs.Range("A1:AM100").Find("January", , _
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)
But it return cell at "A4" (ROW: 4 , COLUMN: 1) because Title Month cell was merged. I can not use this cell for initial iterating and access to all date in this month. How to know a range between A4 was merged?
c# excel vb.net
c# excel vb.net
asked Nov 12 at 11:49
Fame th
389724
asked Nov 12 at 11:49
Fame th
389724
asked Nov 12 at 11:49
Fame th
389724
asked Nov 12 at 11:49
Fame th
389724
asked Nov 12 at 11:49
Fame th
389724
389724
Possible duplicate of VB.net excel merged cells range
– rosi97
Nov 12 at 12:09
Take a look atMergeCellsproperty i.e. you can use:If currentFind.Mergecells Then...
– shrivallabha.redij
Nov 12 at 13:16
add a comment |
Possible duplicate of VB.net excel merged cells range
– rosi97
Nov 12 at 12:09
Take a look atMergeCellsproperty i.e. you can use:If currentFind.Mergecells Then...
– shrivallabha.redij
Nov 12 at 13:16
Possible duplicate of VB.net excel merged cells range
– rosi97
Nov 12 at 12:09
Possible duplicate of VB.net excel merged cells range
– rosi97
Nov 12 at 12:09
Take a look at
MergeCells property i.e. you can use: If currentFind.Mergecells Then...– shrivallabha.redij
Nov 12 at 13:16
Take a look at
MergeCells property i.e. you can use: If currentFind.Mergecells Then...– shrivallabha.redij
Nov 12 at 13:16
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53261552%2fhow-to-get-a-range-from-merged-cell-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53261552%2fhow-to-get-a-range-from-merged-cell-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Possible duplicate of VB.net excel merged cells range
– rosi97
Nov 12 at 12:09
Take a look at
MergeCellsproperty i.e. you can use:If currentFind.Mergecells Then...– shrivallabha.redij
Nov 12 at 13:16