public ParseUsingPathSpec()
{
using (var parser = new ExcelParser(Path))
{
Run(parser);
}
}
public ParseUsingWorksheetSpec()
{
using (var parser = new ExcelParser(Worksheet))
{
Run(parser);
}
}
/// <summary>
/// Otwarcie okna dialogowego do wybrania pliku XLS
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OpenFile_Click(object sender, RoutedEventArgs e)
{
//otwarcie okna dialogowego
Service.FileDialog dialog = new Service.FileDialog();
string FileName = dialog.OpenDialog();
//otwarcie pliku XLS
FileStream fileStream = new FileStream(FileName, FileMode.Open, FileAccess.Read);
ExcelParser xlsManager = new ExcelParser(fileStream);
//parsowanie pliku xls
List <ExcelContent> fileContent = new List <ExcelContent>();
fileContent = xlsManager.ParseExcel();
//dodanie wyniku parsowania do kolekcji
ExcelFiles.Add(new ExcelFile()
{
FileName = FileName,
Content = fileContent
});
excelContent.ItemsSource = rows;
FileList.Items.Refresh();
}
public ParseUsingWorkbookAndSheetNameSpec()
{
using (var parser = new ExcelParser(Workbook, WorksheetName))
{
Run(parser);
}
}
private void ShortDataGrid_Initialized(Object sender, EventArgs e)
{
_collection = new ObservableCollection <ShortData>(ExcelParser.GetShortData(MainWindow.Data));
totalPages.Text = PagesCount.ToString();
currentPage.Text = _currentPage.ToString();
GeneratePageContent(_currentPage);
}
public ParseUsingPathAndSheetNameSpec()
{
using (var parser = new ExcelParser(Path, WorksheetName))
{
Run(parser);
}
}
public static ErrorDict CalculateNormalizedError(CellDict correct_outputs, CellDict partially_corrected_outputs, ErrorDict max_errors)
{
var ed = new ErrorDict();
foreach (KeyValuePair <AST.Address, string> orig in correct_outputs)
{
var addr = orig.Key;
string correct_value = orig.Value;
string partially_corrected_value = System.Convert.ToString(partially_corrected_outputs[addr]);
// if the function produces numeric outputs, calculate distance
if (ExcelParser.isNumeric(correct_value) &&
ExcelParser.isNumeric(partially_corrected_value))
{
ed.Add(addr, RelativeNumericError(System.Convert.ToDouble(correct_value),
System.Convert.ToDouble(partially_corrected_value),
max_errors[addr]));
}
// calculate indicator function
else
{
ed.Add(addr, RelativeCategoricalError(correct_value, partially_corrected_value));
}
}
return(ed);
}
private List <FileRow> ParseDataContent(bool skipFirstLine)
{
switch (SourceType)
{
case SourceType.Excel:
case SourceType.Text:
if (!File.Exists(txtFilePath.Text))
{
throw new Exception("Specified file does not exist");
}
break;
}
switch (SourceType)
{
case SourceType.Excel:
return(ExcelParser.GetValues(txtFilePath.Text, cboSheetName.Text, skipFirstLine));
case SourceType.Text:
return(TextParser.GetValues(txtFilePath.Text, GetDelimiter(), skipFirstLine));
case SourceType.Sql:
return(SqlParser.GetValues(cboConnectionSource.SelectedValue.ToString(), cboTableNameSource.SelectedValue.ToString(), txtFilter.Text));
default:
throw new Exception($"SourceType={SourceType} is not handled");
}
}
public async Task <JsonResult> Add(string date)
{
try
{
var localFile = Server.MapPath(Core.Helper.GetLocalFile(date));
if (System.IO.File.Exists(localFile))
{
var data = await ExcelParser.Parse(localFile);
var count = data.Count();
if (count > 0)
{
await repository.Add(data, date);
}
return(Json(new { success = true, count = data.Count() }));
}
else
{
return(Json(new { success = false, message = "Файл не найден, скачайте его" }));
}
}
catch (Exception ex)
{
Logger logger = LogManager.GetCurrentClassLogger();
logger.Error("Date: {0} {1} \n {2}", date, ex.Message, ex);
}
return(Json(new { success = false, message = "При обработке файла произошла ошибка, обратитесь к разработчикам" }));
}
private void btnParse_Click(object sender, EventArgs e)
{
if (filePath == null)
{
tsslInfo.Text = "Файл не выбран.";
return;
}
try
{
switch (selectedType)
{
case DataType.None:
return;
case DataType.Disciplines:
ExcelParser.ParseDisciplines(out parsedData, filePath);
break;
case DataType.Students:
ExcelParser.ParseStudents(out parsedData, filePath);
break;
case DataType.Teachers:
ExcelParser.ParseTeachers(out parsedData, filePath);
break;
}
tsslInfo.Text = "Файл прочитан.";
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public void UploadAndExtractFreeCountryExcel([FromUri] int id)
{
//从httpRequest中获取文件并写入磁盘系统
var filesGetter = new FilesGetter();
var fileSavePath = filesGetter.GetAndSaveSingleFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
//var excel = new ExcelExtracter(fileSavePath);
//excel.ExtractFCPurchaseOrderSummary(id);
//excel.ExtractFCPurchaseOrderDetail(id);
var parser = new ExcelParser(fileSavePath);
parser.ParseFreeCountryPackingListV2(id);
//强行关闭进程
var killer = new ExcelKiller();
killer.Dispose();
}
//завантаження технологічної карти
private void MenuItem_LoadTechnoCard(object sender, RoutedEventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.Filter = "Excel file (*.xls; *.xlsx)|*.xls; *.xlsx";
if (open.ShowDialog() == true)
{
Table.ItemsSource = null;
LoadingAnimation.Visibility = Visibility.Visible;
new Thread(new ThreadStart(() =>
{
technologicalCard = new ExcelParser(open.FileName).ParseTechnoCard();
if (technologicalCard != null)
{
Table.Dispatcher.Invoke(() => { Table.ItemsSource = technologicalCard.Blocks; });
}
else
{
MessageBox.Show("Не вдалось завантажити технологічну карту", "Помилка");
}
LoadingAnimation.Dispatcher.Invoke(() => { LoadingAnimation.Visibility = Visibility.Collapsed; });
ExcelParser.KillProccess();
})).Start();
}
}
public async Task <IActionResult> MassRegistration(string Path)
{
try
{
ExcelParser ep = new ExcelParser();
MassRegViewModel model = new MassRegViewModel()
{
FIOs = ep.ReadColumn(Path, 0),
Emails = ep.ReadColumn(Path, 1),
Passwords = ep.ReadColumn(Path, 2),
Roles = ep.ReadColumn(Path, 3),
userGrants = await checkService.getUserGrants(User)
};
int em = model.Emails.Count;
int fi = model.FIOs.Count;
int pa = model.FIOs.Count;
int ro = model.Roles.Count;
model.Count = Math.Max(Math.Max(em, fi), Math.Max(pa, ro));
System.IO.File.Delete(Path);
return(View(model));
}
catch (Exception e)
{
return(RedirectToAction("ErrorLoadingFile", "Errors", new { message = e.Message }));
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
Task.Run(() =>
{
Application.Current.Dispatcher.Invoke(() =>
{
Text.Text = "Обучение";
Text.IsEnabled = false;
});
// Database.SetInitializer(new DropCreateDatabaseIfModelChanges<DbEntities>());
var characteristics = _neuroHandler.Db.Characteristics.ToList();
var vocabulary = _neuroHandler.Db.VocabularyWords.ToList();
if (!_neuroHandler.LoadTrainedClassifiers(characteristics, vocabulary))
{
_classifiableText = ExcelParser.XlsxToClassifiableTexts(Path);
vocabulary = _neuroHandler.VocabularySaveToStorage(_classifiableText);
characteristics = _neuroHandler.SaveCharacteristicsToStorage(_classifiableText);
var classifiableTextForTrain = _neuroHandler.SaveClassifiableTextsToStorage(_classifiableText);
_neuroHandler.CreateClassifiers(characteristics, vocabulary);
_neuroHandler.TrainAndSaveClassifiers(classifiableTextForTrain);
_neuroHandler.CheckClassifiersAccuracy(new FileInfo(Path));
}
Application.Current.Dispatcher.Invoke(() =>
{
Text.Text = " ";
Text.IsEnabled = true;
});
});
}
private (bool, string, string) ConvertFiles(string savedFileName, string datastoreName, string scenario)
{
bool success = false;
string message = "";
string savedFilePath = dsManager.GetSavedExcelFilePath(savedFileName);
ExcelParser eParser = new ExcelParser();
(List <Vertex> vertexes, List <Edge> edges) = eParser.ParserExcel(savedFilePath, scenario);
string targetDir = null;
if (vertexes != null && vertexes.Count > 0)
{
targetDir = GenerateKGNLUConfigFiles(vertexes, edges, datastoreName, scenario);
success = true;
}
else
{
message = "无法从上传的 Excel 中解析出实体，请确认该 Excel 与模板格式一致。";
}
return(success, message, targetDir);
}
public ParseUsingWorkbookSpec()
{
using (var parser = new ExcelParser(Workbook))
{
Run(parser);
}
}
private void ImportExcelWorkerDoWork(object sender, DoWorkEventArgs e)
{
// run all background tasks here
try
{
foreach (var name in fileNames)
{
var schedule = ExcelParser.GetScheduleFromExcel(name);
foreach (KeyValuePair <ScheduleRecordDto, List <int> > entry in schedule)
{
bool isAdded = ScheduleRecordDao.AddIfNotExists(entry.Key);
if (!isAdded)
{
continue;
}
foreach (var weekNumber in entry.Value)
{
//TSR
if (weekNumber == 8)
{
continue;
}
WeekScheduleDao.AddWeekSchedule(weekNumber: weekNumber, scheduleRecordId: entry.Key.Id);
}
}
}
}
catch (InvalidInputException ex)
{
ShowPopup(ex.Message);
}
}
// POST api/values
public HttpResponseMessage Post([FromBody] dynamic file)
{
var response = Request.CreateResponse(HttpStatusCode.OK);
var fileContent = Convert.ToString(file);
if (Convert.ToString(file).IsNullOrWhiteSpace())
{
response = Request.CreateResponse(HttpStatusCode.PreconditionFailed, "Error sending data. Please contact the administrator");
}
ExcelParser.PersistExcelData(fileContent);
if (ValidationResult.Validations.Any())
{
string validationMessage = "";
foreach (var validation in ValidationResult.Validations)
{
validationMessage += $"{validation.Key.ToString()} - {validation.Value}";
validationMessage += "\n";
}
response = Request.CreateResponse(HttpStatusCode.ExpectationFailed, validationMessage);
}
return(response);
}
private bool UploadAndImportExcelFile()
{
if (excelFileUpload.HasFile)
{
ClearUploadedSheets();
// Parse and read data from excel file
try
{
ExcelParser parser = new ExcelParser(excelFileUpload.FileContent, excelFileUpload.FileName);
Workbook workbook = parser.GetWorkBook();
UploadedSheets = GetSheets(workbook);
}
catch (Exception ex)
{
ExcelParseEventArgs arg = new ExcelParseEventArgs();
arg.IsSuccessful = false;
arg.Message = string.Format("{0} Please check file format.", ex.Message);
if (ExcelParsing != null)
{
ExcelParsing(this, arg);
}
return(false);
}
return(true);
}
else
{
AlertMessages("Please input excel file.");
return(false);
}
}
private void LoadFileIntoDataTable()
{
if (File.Exists(_FileName))
{
string fileType = _FileName.Substring(_FileName.LastIndexOf(".") + 1);
switch (fileType.ToLower())
{
case "csv":
string csvText = Utilities.readFile(_FileName);
_UploadedSheetTable = CsvParser.Parse(csvText);
break;
case "xls":
case "xlsx":
case "xlsm":
_UploadedSheetTable = ExcelParser.Parse(_FileName);
break;
case "pdf":
_UploadedSheetTable = PDFParser.Parse(_FileName);
break;
default:
break;
}
}
if (_UploadedSheetTable == null)
{
throw new Exception("There was an issue converting the file to a data table.");
}
}
public DataTable GetExcelData()//ContactInfo,FinanceInfo
{
NameValueCollection nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
string FilePath = nvc["FilePath"].ToString();
string SheetName = nvc["SheetName"].ToString();
string AgainstType = nvc["AgainstType"].ToString();
ExcelParser excelObj = new ExcelParser();
DataSet dsXmlFields = excelObj.XmlColumnDefSynonym(AgainstType, ConfigurationManager.ConnectionStrings["ConRenderLogyNew"].ToString(), HttpContext.Current.Server.MapPath("~/CRMFiles/"));
if (dsXmlFields.Tables.Count > 1)
{
DataTable dtExcel = excelObj.ExcelColumnDef(HttpContext.Current.Server.MapPath("~/CRMFiles/") + FilePath, true, SheetName);
if (dtExcel.Rows.Count > 0)
{
var queryRes = (from cs in dsXmlFields.Tables["Name"].AsEnumerable()
join cs1 in dsXmlFields.Tables["Synonyms"].AsEnumerable() on cs["Field_Id"].ToString().ToLower().Trim() equals cs1["Field_Id"].ToString().ToLower().Trim()
join cs2 in dsXmlFields.Tables["Synonym"].AsEnumerable() on cs1["Synonyms_Id"].ToString().ToLower().Trim() equals cs2["Synonyms_Id"].ToString().ToLower().Trim()
join c in dtExcel.AsEnumerable() on cs["Name_Text"].ToString().ToLower().Trim() equals c["COLUMN_NAME"].ToString().ToLower().Trim()
orderby Convert.ToInt32(cs["ColumnOrder"].ToString())
select cs["Name_Text"]).Distinct().ToList();
return(excelObj.GetSpecificColumnsValue(HttpContext.Current.Server.MapPath("~/CRMFiles/") + FilePath, true, SheetName, queryRes, ""));
}
else
{
return(dtExcel);
}
}
else
{
return(dsXmlFields.Tables[0]);
}
}
public async Task <ActionResult> Excel(HttpPostedFileBase file)
{
if (file == null || file.ContentLength == 0)
{
ViewBag.ErrorMessage = "Please Select Valid File";
return(View());
}
if (!file.FileName.EndsWith(".xlsx", StringComparison.OrdinalIgnoreCase))
{
ViewBag.ErrorMessage = "File Type Not Supported";
return(View());
}
ViewBag.FileName = Path.GetFileName(file.FileName);
var ConnectionString = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
var TableName = ConfigurationManager.AppSettings["TargetTableName"];
var ExcelSheetName = ConfigurationManager.AppSettings["ExcelSheetName"];
var parser = new ExcelParser(file.InputStream, ExcelSheetName);
var importer = new Importer(parser, ConnectionString, TableName, 10000);
var Result = await importer.Process();
ViewBag.SuccessCount = Result.Item1;
ViewBag.FailCount = Result.Item2;
return(View("Success", Result.Item3));
}
protected void Run(ExcelParser parser)
{
using (var reader = new CsvReader(parser)) {
reader.Configuration.AutoMap <Person>();
Results = reader.GetRecords <Person>().ToArray();
}
}
public async Task ImportRoster(StorageFile file)
{
_masterRoster.JuniorRoster = await ExcelParser.ParseForScholars(file, Roster.Division.Junior);
_masterRoster.SeniorRoster = await ExcelParser.ParseForScholars(file, Roster.Division.Senior);
UpdateViewModels();
}
public ParseUsingPathWithOffsetsSpec() : base("parse_by_path_with_offset", "Export", 5, 5)
{
using var parser = new ExcelParser(Path)
{
ColumnOffset = StartColumn - 1, RowOffset = StartRow - 1
};
Run(parser);
}
public ParseUsingRangeSpec()
{
var range = Worksheet.Cells[StartRow, StartColumn, StartRow + Values.Length, StartColumn + 1];
using (var parser = new ExcelParser(range)) {
Run(parser);
}
}
private void посмотретьТаблицуЭкспортаToolStripMenuItem_Click(object sender, EventArgs e)
{
if (FormIsOpen("ExcelParser"))
{
ExcelParser excelParser = new ExcelParser();
excelParser.FormClosed += WinFormClosed;
excelParser.Show();
}
}
internal static ITableDataParser CreateParser(string path)
{
//if (CsvParser.CanParse(path)) return new CsvParser(path);
if (ExcelParser.CanParse(path))
{
return(new ExcelParser(path));
}
return(null);
}
internal static bool CanParse(string path)
{
//if (CsvParser.CanParse(path)) return true;
if (ExcelParser.CanParse(path))
{
return(true);
}
return(false);
}
public ParseUsingPathWithOffsetsSpec()
{
using (var parser = new ExcelParser(Path)
{
ColumnOffset = StartColumn - 1, RowOffset = StartRow - 1
}) {
Run(parser);
}
}
public void ParseAllFunds()
{
var parser = new ExcelParser("etfbook.xlsx", 0, new EtfConverterFactory());
var funds = parser.Parse();
var fundsRepository = new FundRepository();
fundsRepository.AddOrUpdate(funds);
}
private IExcelLoader CreateTsdvExcelLoader()
{
var converterManager = new CellTypeValueConverterManager();
var excelBuilder = new AutoCopyrightCoveredExcelBuilder();
var excelParser = new ExcelParser();
var sheetDecorators = new ISheetBuilderDecorator[]
{
new HeaderSheetDecorator(),
new TranslateHeaderDecorator(_localization),
new TextStyleSheetDecorator("Normal"),
new HeaderStyleSheetDecorator("Output"),
new AutoFilterSheetDecorator(),
new AutoFitColumnSheetDecorator(),
new MdsolVersionSheetDecorator()
};
var sheetBuilder = new SheetBuilder(converterManager, sheetDecorators);
var sheetParser = new SheetParser(converterManager);
return new ExcelLoader(excelBuilder, excelParser, sheetBuilder, sheetParser);
}
internal virtual IExcelLoader CreateTsdvExcelLoader()
{
var customConverters = GetCustomCellTypeValueConverters().ToArray();
var converterManager = new CellTypeValueConverterManager(customConverters);
//var excelBuilder = new AutoCopyrightCoveredExcelBuilder();
var excelBuilder = new AutoCopyrightCoveredResourcedExcelBuilder(_resources);
var excelParser = new ExcelParser();
var sheetDecorators = new ISheetBuilderDecorator[]
{
new HeaderSheetDecorator(),
new TranslateHeaderDecorator(_localization),
new TextStyleSheetDecorator("Normal"),
new HeaderStyleSheetDecorator("Output"),
new AutoFilterSheetDecorator(),
new AutoFitColumnSheetDecorator(),
new MdsolVersionSheetDecorator(),
new ColumnDataValidationSheetDecorator(),
};
var sheetBuilder = new SheetBuilder(converterManager, sheetDecorators);
var sheetParser = new SheetParser(converterManager);
return new ExcelLoader(excelBuilder, excelParser, sheetBuilder, sheetParser);
}
static public void ParseAllFundsFromFile(TestContext testContext)
{
var parser = new ExcelParser("etfbookSmallData.xlsx", 0, new EtfConverterExcelFactory());
_allFunds = parser.Parse();
}
public static void ParseAllFundsFromFile(TestContext testContext)
{
var parser = new ExcelParser("Files/FullLightSearch_010716.xlsx", 2, new EtfConverterExcelFactory());
_allFunds = parser.Parse();
}
static public void ParseAllFundsFromFile(TestContext testContext)
{
var parser = new ExcelParser("Files/DataConsolidationExchange_v1_17-06-2016_LightSearchData.xlsx", 0, new EtfConverterExcelFactory());
_allFunds = parser.Parse();
}
