public HttpResponseMessage <SampleTable> GetSampleTable([FromUri] int hrow, [FromUri] int drow, [FromUri] FileInfo fileInfo, [FromUri] string sheet, [FromUri] int?last = null)
{
if (fileInfo == null)
{
throw new WebArgumentNullException(nameof(fileInfo));
}
if (hrow < 0)
{
throw new WebArgumentOutOfRangeException(nameof(hrow));
}
if (drow < 0)
{
throw new WebArgumentOutOfRangeException(nameof(drow));
}
Interface.SampleTable sampleTable;
sampleTable = _spreadsheetInspector.GetSampleTable(fileInfo.FileId, GetFileFormat(fileInfo.FileFormat), sheet, hrow, drow, last);
if (sampleTable == null)
{
return(new HttpResponseMessage <SampleTable>(HttpStatusCode.NotFound));
}
return(new HttpResponseMessage <SampleTable>(PackSampleTable(sampleTable), HttpStatusCode.OK));
}
public static ImportRun RunTest(EntityType entityType, string fileName, ImportFormat importFormat, string sheetName = null)
{
string fileToken;
using (Stream stream = SheetTestHelper.GetStream(fileName))
{
fileToken = FileRepositoryHelper.AddTemporaryFile(stream);
}
EntityType type = entityType;
ImportConfig importConfig = CreateImportConfig(type, importFormat, sheetName);
ImportRun importRun = CreateImportRun(importConfig, fileToken);
ISpreadsheetInspector inspector = Factory.Current.Resolve <ISpreadsheetInspector>( );
SpreadsheetInfo info = inspector.GetSpreadsheetInfo(fileToken, importFormat);
SampleTable sample = inspector.GetSampleTable(fileToken, importFormat, sheetName, 1, 2, null);
AddAllFields(importConfig, sample);
// Run import
IImportRunWorker worker = Factory.Current.Resolve <IImportRunWorker>( );
worker.StartImport(importRun.Id);
return(importRun);
}