C#

Gerry Schmitz

naouf10 wrote:

Does it mean the port did not receive any data ?

.BytesToRead() call

int bytesToRead = 0;

for ( int i = 0; i < 5; i++ ) {
   bytesToRead = _serialPort.BytesToRead;

   if ( bytesToRead > 0 ) {
      break;
   }

   Thread.Sleep( 50 );

}  // end for.

XSSFWorkbook Xwb = new XSSFWorkbook(fs);
HSSFWorkbook Hwb = new HSSFWorkbook(fs);

XSSFSheet Xsh; // what is this ?

StringBuilder sb = new StringBuilder();

String Sheets;
 
switch (Type) {
    case XLSType.XLS:
        for (int i = 0; i < Hwb.Count; i++)
            //Sheets += "\n" + Hwb.GetSheetAt(i).SheetName;
            sb.AppendLine(Hwb.GetSheetAt(i).SheetName);
        break;
    case XLSType.XLSX:
        for (int i = 0; i < Xwb.Count; i++)
            //Sheets += "\n" + Xwb.GetSheetAt(i).SheetName;
            sb.AppendLine(Xwb.GetSheetAt(i).SheetName);
        break;
    default:
        break;
}

Sheets = sb.ToString();

BillWoodruff wrote:

Merry Xmas, Eddy,

BillWoodruff wrote:

In this case, we don't really know what the variable 'Type used in the switch-statement contains

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.IO; 

using NPOI.XSSF.UserModel; // XSSFWorkbook, XSSFSheet
using NPOI.HSSF.UserModel; // HSSFWorkbook, HSSFSheet XLS
using NPOI.SS.UserModel;

namespace XLSManagement
{
	// Classe per la gestione dei file excel con NPOI
	public class NPOIWrapper {

		enum XLSType {XLS, XLSX}

		public string FileName { get; set;}
		private int _CurrentSheetIndex = 0;
		public int CurrentSheetIndex { get {return _CurrentSheetIndex; } set {_CurrentSheetIndex = value; } }

		public NPOIWrapper() { }
		public NPOIWrapper(string cFileName) {
			this.FileName = cFileName;
			ReadXLS();
		}

		private string[] _Sheet;
		public string[] Sheet {get { return _Sheet;} }

		private int _SheetCount = 0;
		public int SheetCount {get { return _SheetCount;} }

		XLSType Type;

        XSSFWorkbook	Xwb;
        HSSFWorkbook	Hwb;
        ISheet[]		sh;

		public bool ReadXLS(string XLSFileName = "") {
			bool Ret = true;
			string XLSName, Extension;
			StringBuilder Sheets = new StringBuilder();

			FileStream fs;
			XLSName = String.IsNullOrEmpty(XLSFileName)?this.FileName:XLSFileName; 
			Extension = Path.GetExtension(XLSName).Substring(1).ToUpper();
			switch (Extension) {
				case "XLS":
					Type = XLSType.XLS;
					break;
				case "XLSX":
					Type = XLSType.XLSX;
					break;
				default:
					Ret = false;
					break;
			}
			if(Ret) {
				fs = new FileStream(XLSName, FileMode.Open, FileAccess.Read);
				if (fs==null) Ret = false;
				else {
					switch (Type) {
						case XLSType.XLS:
							try {
								Hwb = new HSSFWorkbook(fs);
							} catch (Exception ex){ MessageBox.Show("Lettura File XLSX: \n" + ex.Message);}
							_SheetCount = Hwb.Count;
							sh = new ISheet[_SheetCount];
							for (int i = 0; i < _SheetCount; i++) {
								sh[i] = Hwb.GetSheetAt(i);
								Sheets.Append("\n" + sh[i].SheetName);
							}											
							break;
						case XLSType.XLSX:
							try {
								Xwb = new XSSFWorkbook(fs);
							} catch (Exception ex){ MessageBox.Show("Lettura File XLSX: \n" + ex.Message);}
							_SheetCount = Xwb.Count;
							sh = new ISheet[_SheetCount];
							for (int i = 0; i < _SheetCount; i++) {
								sh[i] = Xwb.GetSheetAt(i);
								Sheets.Append("\n" + sh[i].SheetName);
							}											
							break;
						default:
							break;
					}
					this._Sheet = Sheets.ToString().Substring(1).Split('\n');

				}
			}
			return Ret;
		}

		public ICell GetCell(int Row, int Col) {
			ICell Ret;
			Ret = GetCell(Row, Col, this.CurrentSheetIndex);
			return Ret;
		}

		public ICell GetCell(int Row, int Col, int Sheet) {
			ICell Ret;
			Ret = sh[Sheet].GetRow(Row).GetCell(Col);
			return Ret;
		}

		public String GetCellValue(int Row, int Col) {
			String Ret;
			Ret = GetCellValue(Row, Col, this.CurrentSheetIndex);
			return Ret;
		}

		public string GetCellValue(int Row, int Col, int Sheet) {
			string Ret;
			Ret = sh[Sheet].GetRow(Row).GetCell(Col).ToString();
			return Ret;
		}

		public IRow GetRow(int Row, int Sheet) {
			IRow Ret;
			Ret = sh[Sheet].GetRow(Row);
			return Ret;
		}

		public IRow GetRow(int Row) {
			IRow Ret;
			Ret = GetRow(Row, CurrentSheetIndex);
			return Ret;
		}

	}

}

using System;
using System.Reflection;

namespace ConsoleApplication6 {
   class Program {
      static void Main( string[] args ) {
         Run( typeof( Foo ), "butter" );
         Run( typeof( Fee ), "jam" );
      }

      private static void Run( Type t, string s ) {
         object o = Activator.CreateInstance( t );
         MethodInfo mi = o.GetType().GetMethod( "Print" );
         mi.Invoke( o, new object[] { s } );
      }
   }
   class Foo {
      public void Print( string s ) { Console.WriteLine( "I like bread and {0}", s ); }
   }
   class Fee {
      public void Print( string s ) { Console.WriteLine( "I like toast and {0}", s ); }
   }
}