/// <summary> /// /// </summary> /// <param name="AfileName"></param> /// <returns></returns> public Boolean OpenCsvFile(String AfileName) { // We don't need to read the whole file for this because we will only display the first 5 lines bool hasBOM, isAmbiguousUTF; if (TTextFile.AutoDetectTextEncodingAndOpenFile(AfileName, out FFileContent, out FCurrentEncoding, out hasBOM, out isAmbiguousUTF, out FRawBytes) == false) { return(false); } TTextFileEncoding.SetComboBoxProperties(cmbTextEncoding, hasBOM, isAmbiguousUTF, FCurrentEncoding); DisplayGrid(); return(true); }
/// <summary> /// constructor /// TODO: select if first row contains captions? or use a parameter to avoid or request captions? /// </summary> public TDlgSelectCSVSeparator(bool AFileHasCaption) { FFileHasCaption = AFileHasCaption; // // The InitializeComponent() call is required for Windows Forms designer support. // InitializeComponent(); #region CATALOGI18N // this code has been inserted by GenerateI18N, all changes in this region will be overwritten by GenerateI18N this.rbtComma.Text = Catalog.GetString("Comma"); this.rbtTabulator.Text = Catalog.GetString("Tab"); this.rbtOther.Text = Catalog.GetString("Other Separator") + ":"; this.rbtSemicolon.Text = Catalog.GetString("Semicolon"); this.btnCancel.Text = Catalog.GetString("Cancel"); this.btnOK.Text = Catalog.GetString("OK"); this.lblNumberFormat.Text = Catalog.GetString("Number format") + ":"; this.lblNumberFormatHint.Text = Catalog.GetString("Number format Hint") + ":"; this.lblDateFormat.Text = Catalog.GetString("Ambiguous dates") + ":"; this.lblDateFormatHint.Text = Catalog.GetString("Date format Hint") + ":"; this.lblTextEncoding.Text = Catalog.GetString("Text encoding") + ":"; this.lblTextEncodingHint.Text = Catalog.GetString("Hint: Where a choice of encodings exists, a file exported from OpenPetra or Excel"); this.Text = Catalog.GetString("Select CSV Separator"); #endregion FSeparator = TAppSettingsManager.GetValue("CSVSeparator", System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator); System.Globalization.CultureInfo myCulture = System.Threading.Thread.CurrentThread.CurrentCulture; //if (!cmbDateFormat.Items.Contains(regionalDateString)) //{ // cmbDateFormat.Items.Insert(0, regionalDateString); //} //cmbDateFormat.SelectedIndex = cmbDateFormat.Items.IndexOf(regionalDateString); DateFormat = myCulture.DateTimeFormat.ShortDatePattern; cmbNumberFormat.SelectedIndex = cmbNumberFormat.Items.IndexOf(myCulture.NumberFormat.NumberDecimalSeparator); TTextFileEncoding dataSource = new TTextFileEncoding(); this.cmbTextEncoding.ValueMember = TTextFileEncoding.ColumnCodeDbName; this.cmbTextEncoding.DisplayMember = TTextFileEncoding.ColumnDescriptionDbName; this.cmbTextEncoding.DataSource = dataSource.DefaultView; UpdateRadioButtons(); }