/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="eventArgs"></param> private void ExportAllToExcel(object sender, EventArgs eventArgs) { SaveFileDialog sf = new SaveFileDialog { OverwritePrompt = true, Filter = "Excel 2007-2010|*.xlsx|Excel 97-2003|*.xls", AutoUpgradeEnabled = true }; if (sf.ShowDialog(this) != DialogResult.OK) { return; } ExportPart ep = new ExportPart { SheetName = "Elräkningar", AutoFitColumnWidths = true }; ep.Headers.Add("Total förbrukning (kWh)"); ep.Headers.Add("Totalpris el"); ep.Headers.Add("Totalpris grundavgift"); ep.Headers.Add("OCR"); ep.Headers.Add("Datum föregående avläsning"); ep.Headers.Add("Förbrukning föregående avläsning"); ep.Headers.Add("Datum nuvarande avläsning"); ep.Headers.Add("Förbrukning nuvarande avläsning"); ep.Headers.Add("Del i grundavgift"); foreach (Bill b in Bills) { CellDataList cd = new CellDataList(); ep.Data.Add(cd); cd.Add(EFD(b.TotalUsedKWh)); cd.Add(EFD(b.TotalPriceElectricity)); cd.Add(EFD(b.TotalPriceGroundFee)); cd.Add(b.OCR, false); cd.Add(new DateTime(b.GuestLastReadingTicks).ToString("yyyy-MM-dd")); cd.Add(EFD(b.GuestLastReadingKWh)); cd.Add(new DateTime(b.GuestCurrentReadingTicks).ToString("yyyy-MM-dd")); cd.Add(EFD(b.GuestCurrentReadingKWh)); cd.Add(b.GuestPartInGroundFee); } if (File.Exists(sf.FileName)) { try { File.Delete(sf.FileName); } catch (Exception ex) { MessageBox.Show("Kan inte skriva över existerande fil: {0}".FillBlanks(ex.Message)); return; } } using (Stream s = File.OpenWrite(sf.FileName)) { ExcelFactory.ExportList(s, new List <ExportPart>(new[] { ep }), sf.FilterIndex == 1 ? FileFormat.OpenXMLWorkbook : FileFormat.Excel8); s.Flush(); s.Close(); } }
private void ExcelMenuOnClick(object sender, EventArgs eventArgs) { if (selectedAccount == null) { return; } SaveFileDialog sf = new SaveFileDialog { OverwritePrompt = true, Filter = "Excel 2007-2010|*.xlsx|Excel 97-2003|*.xls" }; if (sf.ShowDialog(this) != DialogResult.OK) { return; } ExportPart ep = new ExportPart { SheetName = selectedAccount.Name, AutoFitColumnWidths = true }; ep.Headers.Add("Datum"); ep.Headers.Add("Summa"); ep.Headers.Add("Kommentar"); foreach (AccountTransaction t in selectedAccount.Transactions) { CellDataList cd = new CellDataList(); ep.Data.Add(cd); cd.Add(t.Date); string a = t.Amount.ToString(); if (a.Contains(",")) { a = a.Replace(",", "."); } cd.Add(a); cd.Add(t.Comment); } FileFormat format = sf.FilterIndex == 1 ? FileFormat.OpenXMLWorkbook : FileFormat.Excel8; if (File.Exists(sf.FileName)) { File.Delete(sf.FileName); } using (Stream stream = sf.OpenFile()) { ExcelFactory.ExportList(stream, new List <ExportPart>(new[] { ep }), format); stream.Flush(); } }
public MapData(DlmMap map, MapPosition position = null) { Id= map.Id; Version = map.Version; Encrypted = map.Encrypted; EncryptionVersion = map.EncryptionVersion; RelativeId = map.RelativeId; MapType = map.MapType; SubAreaId = map.SubAreaId; BottomNeighbourId = map.BottomNeighbourId; LeftNeighbourId = map.LeftNeighbourId; RightNeighbourId = map.RightNeighbourId; TopNeighbourId = map.TopNeighbourId; Cells = new CellDataList(map.Cells.Select(x => new CellData(x)).ToArray()); if (position != null) { X = position.posX; Y = position.posY; WorldMap = position.worldMap; Outdoor = position.outdoor; } else { X = ( Id & 0x3FE00 ) >> 9; // 9 higher bits Y = Id & 0x01FF; // 9 lower bits WorldMap = Id & 0x3FFC0000 >> 18; if ((X & 0x100) == 0x100) // 9th bit is the sign. 1 means it's minus { X = -( X & 0xFF ); // just take the 8 first bits and take the opposite number } if (( Y & 0x100 ) == 0x100) // 9th bit is the sign. 1 means it's minus { Y = -( Y & 0xFF ); // just take the 8 first bits and take the opposite number } } }
System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator() { return(CellDataList.GetEnumerator()); }
public virtual IEnumerator <AbstractCellData> GetEnumerator() { return(CellDataList.GetEnumerator()); }
public virtual bool Remove(AbstractCellData item) { return(CellDataList.Remove(item)); }
public virtual void Add(AbstractCellData item) { CellDataList.Add(item); }
public virtual bool Contains(AbstractCellData item) { return(CellDataList.Contains(item)); }
public virtual void RemoveAt(int index) { CellDataList.RemoveAt(index); }
public virtual void Insert(int index, AbstractCellData item) { CellDataList.Insert(index, item); }
public virtual int IndexOf(AbstractCellData item) { return(CellDataList.IndexOf(item)); }
public virtual void Clear() { CellDataList.Clear(); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="eventArgs"></param> private void ExportAllToExcel( object sender, EventArgs eventArgs ) { SaveFileDialog sf = new SaveFileDialog { OverwritePrompt = true, Filter = "Excel 2007-2010|*.xlsx|Excel 97-2003|*.xls", AutoUpgradeEnabled = true }; if( sf.ShowDialog( this ) != DialogResult.OK ) { return; } ExportPart ep = new ExportPart { SheetName = "Elräkningar", AutoFitColumnWidths = true }; ep.Headers.Add( "Total förbrukning (kWh)" ); ep.Headers.Add( "Totalpris el" ); ep.Headers.Add( "Totalpris grundavgift" ); ep.Headers.Add( "OCR" ); ep.Headers.Add( "Datum föregående avläsning" ); ep.Headers.Add( "Förbrukning föregående avläsning" ); ep.Headers.Add( "Datum nuvarande avläsning" ); ep.Headers.Add( "Förbrukning nuvarande avläsning" ); ep.Headers.Add( "Del i grundavgift" ); foreach( Bill b in Bills ) { CellDataList cd = new CellDataList(); ep.Data.Add( cd ); cd.Add( EFD( b.TotalUsedKWh ) ); cd.Add( EFD( b.TotalPriceElectricity ) ); cd.Add( EFD( b.TotalPriceGroundFee ) ); cd.Add( b.OCR, false ); cd.Add( new DateTime( b.GuestLastReadingTicks ).ToString( "yyyy-MM-dd" ) ); cd.Add( EFD( b.GuestLastReadingKWh ) ); cd.Add( new DateTime( b.GuestCurrentReadingTicks ).ToString( "yyyy-MM-dd" ) ); cd.Add( EFD( b.GuestCurrentReadingKWh ) ); cd.Add( b.GuestPartInGroundFee ); } if( File.Exists( sf.FileName ) ) { try { File.Delete( sf.FileName ); } catch( Exception ex ) { MessageBox.Show( "Kan inte skriva över existerande fil: {0}".FillBlanks( ex.Message ) ); return; } } using( Stream s = File.OpenWrite( sf.FileName ) ) { ExcelFactory.ExportList( s, new List<ExportPart>( new[] { ep } ), sf.FilterIndex == 1 ? FileFormat.OpenXMLWorkbook : FileFormat.Excel8 ); s.Flush(); s.Close(); } }
private void ExcelMenuOnClick( object sender, EventArgs eventArgs ) { if( selectedAccount == null ) { return; } SaveFileDialog sf = new SaveFileDialog{OverwritePrompt = true, Filter = "Excel 2007-2010|*.xlsx|Excel 97-2003|*.xls"}; if( sf.ShowDialog(this) != DialogResult.OK) { return; } ExportPart ep = new ExportPart{SheetName = selectedAccount.Name,AutoFitColumnWidths = true}; ep.Headers.Add( "Datum" ); ep.Headers.Add( "Summa" ); ep.Headers.Add( "Kommentar" ); foreach( AccountTransaction t in selectedAccount.Transactions ) { CellDataList cd = new CellDataList(); ep.Data.Add( cd ); cd.Add( t.Date ); string a = t.Amount.ToString(); if( a.Contains( "," ) ) { a = a.Replace( ",", "." ); } cd.Add( a ); cd.Add( t.Comment ); } FileFormat format = sf.FilterIndex == 1 ? FileFormat.OpenXMLWorkbook : FileFormat.Excel8; if( File.Exists( sf.FileName ) ) { File.Delete( sf.FileName ); } using( Stream stream = sf.OpenFile() ) { ExcelFactory.ExportList( stream, new List<ExportPart>( new[] { ep } ), format ); stream.Flush(); } }