無法轉換Cell值到Nullable<T>

[samliu319]

[shps951023]

TargetSite	TargetSite
StackTrace	at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider) at System.Double.System.IConvertible.ToType(Type type, IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at MiniExcelLibs.OpenXml.ExcelOpenXmlSheetReader.Query[T](Stream stream)+MoveNext() at MiniExcelLibs.MiniExcel.Query[T](String path, ExcelType excelType, IConfiguration configuration)+MoveNext() at LINQPad.ObjectGraph.ListNode.GetItems(IEnumerable list, Type staticDumpType, GraphOptions options)+MoveNext() at LINQPad.ObjectGraph.ListNode..ctor(ObjectNode parent, IEnumerable list, Type staticDumpType, GraphOptions options, String name) at LINQPad.ObjectGraph.ObjectNode.CreateInternal(ObjectNode parent, Object item, Type staticDumpType, GraphOptions options, Object itemForDescription, Boolean& collapse) at LINQPad.ObjectGraph.ObjectNode.TryCreate(ObjectNode parent, Object item, Type staticTypeDump, GraphOptions options) at LINQPad.ObjectGraph.ObjectNode.Create(Object item, Type staticDumpType, GraphOptions options) at LINQPad.ObjectGraph.Formatters.HtmlWriter.FormatObject(Object value, String heading, GraphOptions options, Boolean& inline, TimeSpan& formattingTime) at LINQPad.ObjectGraph.Formatters.OutputWriter.WriteObject(Object value, String heading, GraphOptions options, Boolean noNewLine) at LINQPad.ObjectGraph.Formatters.OutputWriter.WriteLineObject(Object value, String heading, GraphOptions options, Boolean noNewLine) at LINQPad.ObjectGraph.Formatters.OutputWriter.WriteLine(Object value) at System.IO.TextWriter.SyncTextWriter.WriteLine(Object value) at System.Console.WriteLine(Object value) at UserQuery.Main() in C:\Users\Wei\AppData\Local\Temp\LINQPad6_qhcxhrod\scabnd\LINQPadQuery:line 4 at LINQPad.ExecutionModel.ClrQueryRunner.Run() at LINQPad.ExecutionModel.Server.RunQuery(QueryRunner runner)
Message	Invalid cast from 'System.Double' to 'System.Nullable`1[[System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'.
Data	Data
InnerException	null
HelpLink	null
Source	System.Private.CoreLib
HResult	-2147467262

[shps951023]

void Main()
{
	//var rows = MiniExcel.Query<Issue138ExcelRow>(@"D:\git\MiniExcel\samples\xlsx\TestIssue138.xlsx");
	//Console.WriteLine(rows);
	
	double d = 111.111;
	var type = typeof(Issue138ExcelRow).GetProperty("波段").PropertyType; //System.Nullable`1[System.Double]
	object d2 = Convert.ChangeType(d, type); //Invalid cast from 'System.Double' to 'System.Nullable`1[[System.Double, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'.
}

// You can define other methods, fields, classes and namespaces here
public class Issue138ExcelRow
{
	public DateTime date { get; set; }	
	public int 實單每日損益 { get; set; }	
	public int 程式每日損益 { get; set; }	
	public string 商品 { get; set; }	
	public string 滿倉口數 { get; set; }
	public double? 波段 { get; set; }
	public double? 當沖 { get; set; }
}

[shps951023]

0.9.1 版本解決此問題