C#

<br />
ExcelObj = new Excel.Application();<br />
<br />
			//  See if the Excel Application Object was successfully constructed<br />
			if (ExcelObj == null)<br />
			{<br />
				MessageBox.Show("ERROR: EXCEL couldn't be started!");<br />
				System.Windows.Forms.Application.Exit();<br />
			}<br />
<br />
			//  Make the Application Visible<br />
			ExcelObj.Visible = false;<br />

<br />
private void DispSheets(string FileName)<br />
		{<br />
			// ***********  Here is the call to Open a Workbook in Excel ****************<br />
			// It uses most of the default values (except for the read-only which we set to true)<br />
			theWorkbook = ExcelObj.Workbooks.Open(<br />
				FileName, 0, true, 5,<br />
				"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,<br />
				0, true, 0, 0);<br />
<br />
			foreach (Excel.Worksheet WrkSht in theWorkbook.Worksheets)<br />
			{<br />
				this.lstWrkSheets.Items.Add(WrkSht.Name);<br />
			}			<br />
		}<br />

<br />
private void btnShowData_Click(object sender, System.EventArgs e)<br />
		{<br />
			int iFirst = 0;<br />
			int iLines = 0;<br />
			this.lstXLSData.Items.Clear();<br />
			//this.lstSelectedColumns.Items.Clear();<br />
<br />
			// get the collection of sheets in the workbook<br />
			Excel.Sheets sheets = theWorkbook.Worksheets;<br />
<br />
			// get the first and only worksheet from the collection of worksheets<br />
			Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(this.lstWrkSheets.SelectedIndex+1);<br />
			<br />
			// find starting row<br />
			iFirst = RowStart();<br />
			<br />
			// find row total<br />
			//iLines = RowTotal();<br />
			iLines = 25;<br />
			<br />
			// loop through user specified rows of the spreadsheet and place each row in the list view<br />
			for (int i = iFirst; i <= iLines; i++)<br />
			{				<br />
				//this.sbpInfo.Text = "Importing row " + i + " of " + iLines;<br />
				Excel.Range range = worksheet.get_Range(this.cmbStartCol.Text + i.ToString(),<br />
					this.cmbEndCol.Text + i.ToString());<br />
				System.Array myvalues = (System.Array)range.Cells.Value2;<br />
				string[] strArray = ConvertToStringArray(myvalues);<br />
				this.lstXLSData.Items.Add(new ListViewItem(strArray));<br />
			}<br />
		}<br />
private string[] ConvertToStringArray(System.Array values)<br />
		{ <br />
			// create a new string array<br />
			string[] theArray = new string[values.Length];<br />
<br />
			// loop through the 2-D System.Array and populate the 1-D String Array<br />
			for (int i = 1; i <= values.Length; i++)<br />
			{<br />
				if (values.GetValue(1, i) == null)<br />
					theArray[i-1] = "";<br />
				else<br />
					theArray[i-1] = (string)values.GetValue(1, i).ToString();<br />
			}<br />
<br />
			return theArray;<br />
		}<br />

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Moral Muscle
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango