Skip to content

Instantly share code, notes, and snippets.

@ArnisL

ArnisL/excel_reader.cs

Created August 30, 2010 13:38
Show Gist options
  • Save ArnisL/557406 to your computer and use it in GitHub Desktop.
Save ArnisL/557406 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
excel_reader.cs
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT13 = true;
}
else
{
invRow.AT13 = false;
}
sTemp =
_Excel.getCellAsString(2,4,38).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT11 = true;
}
else
{
invRow.AT11 = false;
}
sTemp =
_Excel.getCellAsString(2,4,39).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT12 = true;
}
else
{
invRow.AT12 = false;
}
sTemp =
_Excel.getCellAsString(2,4,40).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT21 = true;
}
else
{
invRow.AT21 = false;
}
sTemp =
_Excel.getCellAsString(2,4,41).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT22 = true;
}
else
{
invRow.AT22 = false;
}
sTemp =
_Excel.getCellAsString(2,4,42).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT31 = true;
}
else
{
invRow.AT31 = false;
}
sTemp =
_Excel.getCellAsString(2,4,43).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT32 = true;
}
else
{
invRow.AT32 = false;
}
sTemp =
_Excel.getCellAsString(2,4,44).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT33 = true;
}
else
{
invRow.AT33 = false;
}
sTemp =
_Excel.getCellAsString(2,4,45).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.AT34 = true;
}
else
{
invRow.AT34 = false;
}
sTemp =
_Excel.getCellAsString(2,4,46).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.FR42 = true;
}
else
{
invRow.FR42 = false;
}
sTemp =
_Excel.getCellAsString(2,4,47).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.FR43 = true;
}
else
{
invRow.FR43 = false;
}
sTemp =
_Excel.getCellAsString(2,4,48).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.FR71 = true;
}
else
{
invRow.FR71 = false;
}
sTemp =
_Excel.getCellAsString(2,4,49).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.FR82 = true;
}
else
{
invRow.FR82 = false;
}
sTemp =
_Excel.getCellAsString(2,4,50).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.DE13 = true;
}
else
{
invRow.DE13 = false;
}
sTemp =
_Excel.getCellAsString(2,4,51).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.DE14 = true;
}
else
{
invRow.DE14 = false;
}
sTemp =
_Excel.getCellAsString(2,4,52).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.DE21 = true;
}
else
{
invRow.DE21 = false;
}
sTemp =
_Excel.getCellAsString(2,4,53).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.DE27 = true;
}
else
{
invRow.DE27 = false;
}
sTemp =
_Excel.getCellAsString(2,4,54).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT2 = true;
}
else
{
invRow.IT2 = false;
}
sTemp =
_Excel.getCellAsString(2,4,55).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT11 = true;
}
else
{
invRow.IT11 = false;
}
sTemp =
_Excel.getCellAsString(2,4,56).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT12 = true;
}
else
{
invRow.IT12 = false;
}
sTemp =
_Excel.getCellAsString(2,4,57).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT13 = true;
}
else
{
invRow.IT13 = false;
}
sTemp =
_Excel.getCellAsString(2,4,58).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT31 = true;
}
else
{
invRow.IT31 = false;
}
sTemp =
_Excel.getCellAsString(2,4,59).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT32 = true;
}
else
{
invRow.IT32 = false;
}
sTemp =
_Excel.getCellAsString(2,4,60).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.IT33 = true;
}
else
{
invRow.IT33 = false;
}
sTemp =
_Excel.getCellAsString(2,4,61).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.SLOVENIA = true;
}
else
{
invRow.SLOVENIA = false;
}
sTemp =
_Excel.getCellAsString(2,4,64).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_1 = true;
}
else
{
invRow.N_EU_1 = false;
}
sTemp =
_Excel.getCellAsString(2,4,65).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_2 = true;
}
else
{
invRow.N_EU_2 = false;
}
sTemp =
_Excel.getCellAsString(2,4,66).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_3 = true;
}
else
{
invRow.N_EU_3 = false;
}
sTemp =
_Excel.getCellAsString(2,4,67).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_4 = true;
}
else
{
invRow.N_EU_4 = false;
}
sTemp =
_Excel.getCellAsString(2,4,68).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_5 = true;
}
else
{
invRow.N_EU_5 = false;
}
sTemp =
_Excel.getCellAsString(2,4,69).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_6 = true;
}
else
{
invRow.N_EU_6 = false;
}
sTemp =
_Excel.getCellAsString(2,4,70).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_7 = true;
}
else
{
invRow.N_EU_7 = false;
}
sTemp =
_Excel.getCellAsString(2,4,71).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_8 = true;
}
else
{
invRow.N_EU_8 = false;
}
sTemp =
_Excel.getCellAsString(2,4,72).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_9 = true;
}
else
{
invRow.N_EU_9 = false;
}
sTemp =
_Excel.getCellAsString(2,4,73).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_10 = true;
}
else
{
invRow.N_EU_10 = false;
}
sTemp =
_Excel.getCellAsString(2,4,74).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_11 = true;
}
else
{
invRow.N_EU_11 = false;
}
sTemp =
_Excel.getCellAsString(2,4,75).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_12 = true;
}
else
{
invRow.N_EU_12 = false;
}
sTemp =
_Excel.getCellAsString(2,4,76).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_13 = true;
}
else
{
invRow.N_EU_13 = false;
}
sTemp =
_Excel.getCellAsString(2,4,77).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_14 = true;
}
else
{
invRow.N_EU_14 = false;
}
sTemp =
_Excel.getCellAsString(2,4,78).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_15 = true;
}
else
{
invRow.N_EU_15 = false;
}
sTemp =
_Excel.getCellAsString(2,2,66).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_16 = true;
}
else
{
invRow.N_EU_16 = false;
}
sTemp =
_Excel.getCellAsString(2,2,67).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_17 = true;
}
else
{
invRow.N_EU_17 = false;
}
sTemp =
_Excel.getCellAsString(2,2,68).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_18 = true;
}
else
{
invRow.N_EU_18 = false;
}
sTemp =
_Excel.getCellAsString(2,2,69).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_19 = true;
}
else
{
invRow.N_EU_19 = false;
}
sTemp =
_Excel.getCellAsString(2,2,70).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_20 = true;
}
else
{
invRow.N_EU_20 = false;
}
sTemp =
_Excel.getCellAsString(2,2,71).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_21 = true;
}
else
{
invRow.N_EU_21 = false;
}
sTemp =
_Excel.getCellAsString(2,2,72).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_22 = true;
}
else
{
invRow.N_EU_22 = false;
}
sTemp =
_Excel.getCellAsString(2,2,73).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_23 = true;
}
else
{
invRow.N_EU_23 = false;
}
sTemp =
_Excel.getCellAsString(2,2,74).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_24 = true;
}
else
{
invRow.N_EU_24 = false;
}
sTemp =
_Excel.getCellAsString(2,2,75).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_25 = true;
}
else
{
invRow.N_EU_25 = false;
}
sTemp =
_Excel.getCellAsString(2,2,76).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_26 = true;
}
else
{
invRow.N_EU_26 = false;
}
sTemp =
_Excel.getCellAsString(2,2,77).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_27 = true;
}
else
{
invRow.N_EU_27 = false;
}
sTemp =
_Excel.getCellAsString(2,2,78).Replace("''","'").Replace("'","''");
if ((sTemp.IndexOf(".") == -1) && (sTemp.Length >= 1) &&
(sTemp.ToUpper().IndexOf("N") == -1) && (sTemp.IndexOf("-") == -1))
{
invRow.N_EU_28 = true;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment