Styjun

Does the Voyager team use a wrapper (Fortran(77?) to Python) to transmit current commands?

Does this put me at risk for identity theft?

The heat content of the products is more than that of the reactant in an ............. reaction

Where to pee in London?

If someone else uploads my GPL'd code to Github without my permission, is that a copyright violation?

is it possible to terraform a planet made of human excrement into habitable planet?

How to halve redstone signal strength?

Why do proponents of guns oppose gun competency tests?

Secure my password from unsafe servers

Can chords be inferred from melody alone?

Is it double speak?

What is an air conditioner compressor hard start kit and how does it work?

Can I enter a rental property without giving notice if I'm afraid a tenant may be hurt?

Did silent film actors actually say their lines or did they simply improvise “dialogue” while being filmed?

Should I take out a personal loan to pay off credit card debt?

Why does putting a dot after the URL remove login information?

Was Richard I's imprisonment by Leopold of Austria justified?

How to draw a flow chart?

Is a switch from R to Python worth it?

Can ads on a page read my password?

What could prevent players from leaving an island?

Can this code, to convert string to integer, be made more compact?

Why don't the open notes matter in guitar chords?

Does this smartphone photo show Mars just below the Sun?

npoi c# column number discrepency [duplicate]

How to use NPOI to read Excel spreadsheet that contains empty cells?How do I calculate someone's age in C#?What is the difference between String and string in C#?Hidden Features of C#?Cast int to enum in C#How do I enumerate an enum in C#?How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?What are the correct version numbers for C#?How do I get a consistent byte representation of strings in C# without manually specifying an encoding?How do I generate a random int number?Why not inherit from List<T>?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

This question already has an answer here:

• 
  How to use NPOI to read Excel spreadsheet that contains empty cells?
  
  1 answer
  
  

I'm trying to parse an excel spreadsheet, which in the past has been a breeze with the C# NPOI port. However, this time I'm finding that column "0" is changing from one row to the next.

I am trying to access the Cells property of an HSSFRow. It seems that cell 0 starts with the first cell that has data, rather than the first actual cell. At first I thought it was just the first cell that wasn't hidden... then I thought well maybe it's just the first cell that's after the freeze pane. Of course both those possibilities raise their own issues, but now it seems I'm finding that cell 0 is just the first one with data.

I'm trying to parse a spreadsheet that was definitely not designed with the intention of being parsed (the company who produced the spreadsheet is happy for us to use it this way, they just don't have the resources to provide a better source for our purposes at the moment).

So the data columns are staggered such that, instead of repeating a value in a column for every row, you just assume a value is repeated for every (blank cell in a) row until a new value is provided (hopefully that makes sense?).

The NPOI implementation seems to ignore/truncate empty cells though and act as though a value in any cell can be cell 0 so long as there was no data in any cell before it. This is super frustrating. How can I access data from a specific column that is ACTUALLY that column in the real spreadsheet?

c# excel npoi

share|improve this question

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

marked as duplicate by Tim Williams excel
Users with the  excel badge can single-handedly close excel questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Mar 27 at 5:28

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  stackoverflow.com/questions/17475359/…
  
  – Tim Williams
  Mar 27 at 5:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @TimWilliams Thank you. I started trying to compensate by subtracting the starting row but for whatever reason that didn't give me consistent results and I was about to ready to pull my hair out.
  
  – BVernon
  Mar 27 at 6:20
  

  
  
  
  

add a comment | 

0

This question already has an answer here:

• 
  How to use NPOI to read Excel spreadsheet that contains empty cells?
  
  1 answer
  
  

I'm trying to parse an excel spreadsheet, which in the past has been a breeze with the C# NPOI port. However, this time I'm finding that column "0" is changing from one row to the next.

I am trying to access the Cells property of an HSSFRow. It seems that cell 0 starts with the first cell that has data, rather than the first actual cell. At first I thought it was just the first cell that wasn't hidden... then I thought well maybe it's just the first cell that's after the freeze pane. Of course both those possibilities raise their own issues, but now it seems I'm finding that cell 0 is just the first one with data.

I'm trying to parse a spreadsheet that was definitely not designed with the intention of being parsed (the company who produced the spreadsheet is happy for us to use it this way, they just don't have the resources to provide a better source for our purposes at the moment).

So the data columns are staggered such that, instead of repeating a value in a column for every row, you just assume a value is repeated for every (blank cell in a) row until a new value is provided (hopefully that makes sense?).

The NPOI implementation seems to ignore/truncate empty cells though and act as though a value in any cell can be cell 0 so long as there was no data in any cell before it. This is super frustrating. How can I access data from a specific column that is ACTUALLY that column in the real spreadsheet?

c# excel npoi

share|improve this question

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

marked as duplicate by Tim Williams excel
Users with the  excel badge can single-handedly close excel questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Mar 27 at 5:28

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  stackoverflow.com/questions/17475359/…
  
  – Tim Williams
  Mar 27 at 5:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @TimWilliams Thank you. I started trying to compensate by subtracting the starting row but for whatever reason that didn't give me consistent results and I was about to ready to pull my hair out.
  
  – BVernon
  Mar 27 at 6:20
  

  
  
  
  

add a comment | 

This question already has an answer here:

• 
  How to use NPOI to read Excel spreadsheet that contains empty cells?
  
  1 answer
  
  

I'm trying to parse an excel spreadsheet, which in the past has been a breeze with the C# NPOI port. However, this time I'm finding that column "0" is changing from one row to the next.

I am trying to access the Cells property of an HSSFRow. It seems that cell 0 starts with the first cell that has data, rather than the first actual cell. At first I thought it was just the first cell that wasn't hidden... then I thought well maybe it's just the first cell that's after the freeze pane. Of course both those possibilities raise their own issues, but now it seems I'm finding that cell 0 is just the first one with data.

I'm trying to parse a spreadsheet that was definitely not designed with the intention of being parsed (the company who produced the spreadsheet is happy for us to use it this way, they just don't have the resources to provide a better source for our purposes at the moment).

So the data columns are staggered such that, instead of repeating a value in a column for every row, you just assume a value is repeated for every (blank cell in a) row until a new value is provided (hopefully that makes sense?).

The NPOI implementation seems to ignore/truncate empty cells though and act as though a value in any cell can be cell 0 so long as there was no data in any cell before it. This is super frustrating. How can I access data from a specific column that is ACTUALLY that column in the real spreadsheet?

c# excel npoi

share|improve this question

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

share|improve this question

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

share|improve this question

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

asked Mar 27 at 5:10

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

1 Answer
1

active

oldest

votes

0

Looks like I should have perused through the properties a little more carefully before posting this question. There is a property called FirstCellNum on the HSSFRow.

Personally I think this is confusing and that it would have made more sense to simply return a null value for cells requested before the first one with data rather then requiring the consumer to pay attention to this property and add it to the value of the column number they want to access. But oh well, this is how they chose to implement it.

share|improve this answer

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

add a comment | 

0

Looks like I should have perused through the properties a little more carefully before posting this question. There is a property called FirstCellNum on the HSSFRow.

Personally I think this is confusing and that it would have made more sense to simply return a null value for cells requested before the first one with data rather then requiring the consumer to pay attention to this property and add it to the value of the column number they want to access. But oh well, this is how they chose to implement it.

share|improve this answer

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

add a comment | 

0

Looks like I should have perused through the properties a little more carefully before posting this question. There is a property called FirstCellNum on the HSSFRow.

Personally I think this is confusing and that it would have made more sense to simply return a null value for cells requested before the first one with data rather then requiring the consumer to pay attention to this property and add it to the value of the column number they want to access. But oh well, this is how they chose to implement it.

share|improve this answer

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

add a comment | 

Looks like I should have perused through the properties a little more carefully before posting this question. There is a property called FirstCellNum on the HSSFRow.

Personally I think this is confusing and that it would have made more sense to simply return a null value for cells requested before the first one with data rather then requiring the consumer to pay attention to this property and add it to the value of the column number they want to access. But oh well, this is how they chose to implement it.

share|improve this answer

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

share|improve this answer

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges

answered Mar 27 at 5:25

BVernonBVernon

97622 gold badges1515 silver badges4141 bronze badges