private void FillSheet(string separateBy)
{
WriteData(CreateHeader(), separateBy);
if ((_excelApp.ActiveSheet as _Worksheet).Range["A1"].Value2 != null)
{
_sheet = _sheets.Add();
_sheet.Select();
}
}
private AnswerSheet CreateAnswerSheetInternalFor(string name)
{
AnswerSheet a = new AnswerSheet(name, this);
Sheets.Add(a);
return(a);
}
/// <summary>
/// シートを作成する
/// ※カレントシートは変更しない
/// </summary>
/// <param name="sheetName"></param>
public void CreateSheet(string sheetName, SheetPosition position)
{
Worksheet lastSheet = null;
Worksheet newSheet = null;
try
{
lastSheet = xlSheets[xlSheets.Count];
newSheet = xlSheets.Add(After: lastSheet);
newSheet.Name = sheetName;
MoveLastSheet(position);
}finally
{
if (newSheet != null)
{
Marshal.ReleaseComObject(newSheet);
}
newSheet = null;
if (lastSheet != null)
{
Marshal.ReleaseComObject(lastSheet);
}
lastSheet = null;
}
}
internal XlsWorkbook(Stream stream, string password, Encoding fallbackEncoding)
{
Stream = stream;
using (var biffStream = new XlsBiffStream(stream, 0, 0, password))
{
if (biffStream.BiffVersion == 0)
{
throw new ExcelReaderException(Errors.ErrorWorkbookGlobalsInvalidData);
}
BiffVersion = biffStream.BiffVersion;
SecretKey = biffStream.SecretKey;
Encryption = biffStream.Encryption;
Encoding = biffStream.BiffVersion == 8 ? Encoding.Unicode : fallbackEncoding;
if (biffStream.BiffType == BIFFTYPE.WorkbookGlobals)
{
ReadWorkbookGlobals(biffStream);
}
else if (biffStream.BiffType == BIFFTYPE.Worksheet)
{
// set up 'virtual' bound sheet pointing at this
Sheets.Add(new XlsBiffBoundSheet(0, XlsBiffBoundSheet.SheetType.Worksheet, XlsBiffBoundSheet.SheetVisibility.Visible, "Sheet"));
}
else
{
throw new ExcelReaderException(Errors.ErrorWorkbookGlobalsInvalidData);
}
}
}
/// <summary>
/// Setup workbooks/worksheets and populate them
/// </summary>
public void Initialize()
{
//_application.Workbooks.add(...) is not possible.
//2 dots must be avoided to release wrappers: http://support.microsoft.com/kb/317109
Workbooks workbooks = _application.Workbooks;
_workbook = workbooks.Add(Missing.Value);
Sheets worksheets = _workbook.Worksheets;
_worksheet = (Worksheet)_workbook.ActiveSheet;
_worksheetHidden = (Worksheet)worksheets.Add();
// Release wrapper objects
Marshal.FinalReleaseComObject(worksheets);
Marshal.FinalReleaseComObject(workbooks);
_worksheetHidden.Name = "Mapping Information";
_worksheetHidden.Visible = XlSheetVisibility.xlSheetVeryHidden;
//Event handlers
_worksheet.Change += Event_ChangeEvent;
Populate();
_application.Visible = true; //Show the application after it's populated
}
/// <summary>
/// Adds a new sheet to this book.
/// </summary>
public bool AddSheet(string sheetName, int rows, int cols)
{
// make sure we have sheets
ApplyTemplate();
if (Sheets == null)
{
return false;
}
// create a new sheet
var newSheet = new Sheet();
newSheet.Name = sheetName;
// add rows and columns to the sheet
for (int r = 0; r < rows; r++)
{
newSheet.Grid.Rows.Add(new ExcelRow());
}
for (int c = 0; c < cols; c++)
{
newSheet.Grid.Columns.Add(new Column());
}
// add sheet to grid, select it
Sheets.Add(newSheet);
Sheets.SelectedSheet = newSheet;
// done
return true;
}
public void AddStyleSheets(params StyleSheet[] sheets)
{
foreach (var sheet in sheets)
{
Sheets.Add(sheet);
}
}
// Método de exportar arquivo excel usando a dll Microsoft.Office.Interop.Excel
public static void ExportToExcelUsingMicrosoft <T>(T item)
{
// Representa o programa excel instalado no PC do usuário
Application app = new Application();
// Representa um arquivo excel
Workbook excelFile = app.Workbooks.Add();
// Representa as abas dos excel
Sheets sheets = excelFile.Worksheets;
// Cria uma aba em específico
Worksheet usuarioSheet = sheets.Add() as Worksheet;
usuarioSheet.Name = "Usuários";
PopulateSheet(usuarioSheet, item);
// Se houver mais de uma aba, a de usuários terá o foco.
usuarioSheet.Activate();
usuarioSheet.Columns.AutoFit();
app.Visible = true;
SaveExcelFile(excelFile, "");
}
public static void writeExcel(string fileName)
{
/*if (!File.Exists(fileName))
* {
* File.Create(fileName);
* }*/
object obj = System.Reflection.Missing.Value;
Application app = new Application();
app.Visible = false; //后台运行
app.Workbooks.Add(obj);
app.DisplayAlerts = false; //设置不显示确认修改提示
Workbook wb = app.ActiveWorkbook; //创建workbook，是内存中的excel文件
Sheets sheets = wb.Sheets; //获取workbook中的sheet
Worksheet ws = sheets.Add(); //添加一个sheet
ws.Name = "表一"; //设置sheet的名字
ws.Cells[1, 1].Value = "编号";
ws.Cells[1, 2].Value = "名字";
ws.Cells[1, 3].Value = "随机数";
int j = 1;
Random rd = new Random();
for (int i = 2; i < 10; i++)
{
ws.Cells[i, 1].Value = j;
ws.Cells[i, 2].Value = "张三";
ws.Cells[i, 3].Value = rd.Next(100, 999);
}
//fileName = "@"+fileName;
ws.SaveAs(fileName); //将内存中的文件保存到硬盘中
wb.Close(false, Type.Missing, Type.Missing); //关闭workbook
app.Quit();
}
public static Worksheet AddTableToWorkSheet(Workbook wb, System.Data.DataTable t1, string name)
{
try
{
Sheets sheets = wb.Sheets;
Worksheet newSheet = sheets.Add();
newSheet.Name = name;
int iCol = 0;
foreach (DataColumn c in t1.Columns)
{
iCol++;
newSheet.Cells[1, iCol] = c.ColumnName;
}
int iRow = 0;
foreach (DataRow r in t1.Rows)
{
iRow++;
// add each row's cell data...
iCol = 0;
foreach (DataColumn c in t1.Columns)
{
iCol++;
newSheet.Cells[iRow + 1, iCol] = r[c.ColumnName];
}
}
return(newSheet);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public void AddSheet(InventorSheet inventorSheet)
{
var newSheet = new SheetCaptureDto(inventorSheet);
newSheet.DrawingId = Id;
Sheets.Add(newSheet);
}
public void AddStyleSheet(string sheetPath)
{
var sheet = ConverterUtils.LoadResourceRequired <StyleSheet>(sheetPath);
if (sheet != null)
{
Sheets.Add(sheet);
}
}
private void ReadWSheets()
{
WorkSheets.Clear();
foreach (Sheet sheet in SDoc.WorkbookPart.Workbook.Descendants <Sheet>())
{
Sheets.Add(sheet);
WorkSheets.Add(new ExWs(sheet, this));
}
}
/// <summary>
/// Add an existing sheet to the
/// </summary>
/// <param name="sheetName">workbookk´s sheet name</param>
/// <returns></returns>
public ExcelTestCaseDataReader AgregarHoja(string sheetName)
{
if (Sheets == null)
{
Sheets = new List <string>();
}
Sheets.Add(sheetName);
return(this);
}
/// <summary>
/// Add an existing sheet to the
/// </summary>
/// <param name="sheetName">workbookk´s sheet name</param>
/// <returns></returns>
public ExcelDataReader AddSheet(string sheet)
{
if (Sheets == null)
{
Sheets = new List <string>();
}
Sheets.Add(sheet);
return(this);
}
public void AddWorksheetToExcelWorkbook(string fullFilename, string worksheetName, GridView gridview)
{
Microsoft.Office.Interop.Excel.Application xlApp = null;
Workbook xlWorkbook = null;
Sheets xlSheets = null;
Worksheet xlNewSheet = null;
try
{
xlApp = new Microsoft.Office.Interop.Excel.Application();
//if (xlApp == null)
// return;
// Uncomment the line below if you want to see what's happening in Excel
// xlApp.Visible = true;
xlWorkbook = xlApp.Workbooks.Open(fullFilename, 0, false, 5, "", "",
false, XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
xlSheets = xlWorkbook.Sheets as Sheets;
// The first argument below inserts the new worksheet as the first one
xlNewSheet = (Worksheet)xlSheets.Add(xlSheets[1], Type.Missing, Type.Missing, Type.Missing);
xlNewSheet.Name = worksheetName;
xlNewSheet.Cells.Insert(0, 0);
//---------------------
int i = 0;
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Normal);
TableCell cell = new TableCell();
cell.Text = String.Format(worksheetName, i);
row.Cells.Add(cell);
gridview.Controls[0].Controls.AddAt(i, row);
//---------------------
xlWorkbook.Save();
xlWorkbook.Close(Type.Missing, Type.Missing, Type.Missing);
xlApp.Quit();
}
catch (Exception lkjlklkabb)
{
}
finally
{
//Marshal.ReleaseComObject(xlNewSheet);
//Marshal.ReleaseComObject(xlSheets);
//Marshal.ReleaseComObject(xlWorkbook);
//Marshal.ReleaseComObject(xlApp);
xlApp = null;
}
}
protected override IExternalExcelSheet AddOrGetInternal(string sheetName)
{
if (_obj == null)
{
return(null);
}
Worksheet ws = null;
bool exists = false;
if (!_write)
{
foreach (var ws1 in _worksheets.OfType <Worksheet>())
{
try
{
if (ws1.Name.IgnoreCaseCompare(sheetName))
{
ws = ws1;
exists = true;
break;
}
}
catch { }
finally
{
if (!exists)
{
Extensions.DisposeComObject(ws);
}
}
}
}
if (ws == null)
{
ws = _worksheets.Add();
ws.Name = sheetName;
}
Range rows = ws.Rows;
try
{
rows.Locked = false;
}
finally { Extensions.DisposeComObject(rows); }
object missing = Type.Missing;
ws.Protect(missing, missing, false, missing, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing);
return(new MsOfficeExcelSheet(ws));
}
public SFapp()
{
Sheet s = new Sheet()
{
Name = "Prova", Date = "11/22/3333", WeeklyFrequency = 5
};
s.AddRange(Day);
Day.First().AddRange(Exercices);
Sheets.Add(s);
}
private void InitPage()
{
for (int i = 0; i < MaxItems; i++)
{
Sheets.Add(new Sheet());
if (i == 0 && Sheets[i] != null)
{
Sheets[i].IsCurrent = true;
}
}
}
/// <summary>
/// Pulls all sheet data from the API.
/// </summary>
/// <returns></returns>
public async Task Get()
{
var requestSheet = Service.Spreadsheets.Get(ID);
var requestSheetResponse = await requestSheet.ExecuteAsync();
foreach (var sheet in requestSheetResponse.Sheets)
{
var s = new Sheet(this, sheet.Properties.SheetId.Value, sheet.Properties.Title);
Sheets.Add(s);
}
}
/// <summary>
/// 初始化Fp。
/// </summary>
/// <param name="report">报表实体。</param>
public void Init(Report report)
{
this.report = report;
//获取报表样样式，判定是否可以编辑报表列。对于网格报表这样的样式，是可以编辑列的。对于交叉报表，是不能编辑列的。
BaseReportStyle reportStyle = this.report.ReportStyle;
canEditColumn = reportStyle.CanEditColumn();
Sheets.Clear();
Sheets.Add(sheetMain);
InitFP();
}
public void AddSheet(int w, int h, int src)
{
var tt = new RectangleSheet();
tt.Name = "sheet" + (Sheets.Count + 1);
Sheets.Add(tt);
tt.source = src;
tt.Height = h;
tt.Width = w;
tt.Rebuild();
ReorderSheets();
}
public async Task <Sheet> AddSheet(string name)
{
var sheet = new Sheet(this, Sheets.Count, name);
Sheets.Add(sheet);
var batchRequest = new BatchUpdateSpreadsheetHelper(ID);
batchRequest.Add((request) =>
{
// By default, a spreadsheet already has one sheet.
// If there is more than one sheet, create a new one.
// Otherwise, just update the title of the first one.
if (Sheets.Count > 1)
{
request.AddSheet = new AddSheetRequest()
{
Properties = new SheetProperties()
{
SheetId = Sheets.Count - 1,
Title = name,
GridProperties = new GridProperties()
{
ColumnCount = 1,
RowCount = 1,
}
},
};
}
else
{
request.UpdateSheetProperties = new UpdateSheetPropertiesRequest()
{
Properties = new SheetProperties()
{
Title = name,
GridProperties = new GridProperties()
{
ColumnCount = 1,
RowCount = 1,
}
},
Fields = "*",
};
}
});
await batchRequest.ExecuteAsync(Service);
return(sheet);
}
private void Exp()
{
FileInfo newFile = new FileInfo(@"\\192.168.12.33\oms-reports\ProductionRep.xlsx");
Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();
// ExcelApp.Visible = true;
Workbook xlWorkbook = ExcelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
DataTableCollection collection = ds.Tables;
for (int i = collection.Count; i > 0; i--)
{
Sheets xlSheets = null;
Worksheet xlWorksheet = null;
//Create Excel Sheets
xlSheets = ExcelApp.Worksheets;
xlWorksheet = (Worksheet)xlSheets.Add(xlSheets[1],
Type.Missing, Type.Missing, Type.Missing);
System.Data.DataTable table = collection[i - 1];
xlWorksheet.Name = table.TableName;
for (int j = 1; j < table.Columns.Count + 1; j++)
{
ExcelApp.Cells[1, j] = table.Columns[j - 1].ColumnName;
}
// Storing Each row and column value to excel sheet
for (int k = 0; k < table.Rows.Count; k++)
{
for (int l = 0; l < table.Columns.Count; l++)
{
ExcelApp.Cells[k + 2, l + 1] =
table.Rows[k].ItemArray[l].ToString();
}
}
// xlWorksheet.Cells[0, 0].Style.IsTextWrapped = true;
ExcelApp.Columns.AutoFit();
}
((Worksheet)ExcelApp.ActiveWorkbook.Sheets[ExcelApp.ActiveWorkbook.Sheets.Count]).Delete();
//ExcelApp.Visible = true;
// xlWorkbook.SaveCopyAs(@"C:\Niranjan.xlsx");
// xlWorkbook.SaveCopyAs(@"D:\Export\ProductionRep.xlsx");
xlWorkbook.SaveCopyAs(newFile);
ExcelApp.DisplayAlerts = false;
xlWorkbook.Close();
ExcelApp.Quit();
}
/// <summary>
/// Creates a workbook containing the specified number of sheets (not less than 1).
/// </summary>
/// <remarks>If <paramref name="numberOfSheets"/> is less than 1, the workbook will still
/// contain one worksheet.</remarks>
/// <param name="numberOfSheets">Number of sheets in the new workbook.</param>
/// <returns>Workbook containing the specified number of sheets (not less than 1).</returns>
public Workbook CreateWorkbook(int numberOfSheets)
{
Logger.Info("CreateWorkbook({0})", numberOfSheets);
Workbook wb = CreateWorkbook();
Sheets sheets = wb.Sheets;
for (int i = 2; i <= numberOfSheets; i++)
{
sheets.Add(After: sheets[sheets.Count]);
}
;
Bovender.ComHelpers.ReleaseComObject(sheets);
return(wb);
}
private void GetSheets(ExcelMappingElement excelMappingElement)
{
foreach (var sheetElement in excelMappingElement.Sheets)
{
Sheets.Add(new SheetConfig
{
NoSheet = sheetElement.NoSheet,
SheetName = sheetElement.SheetName,
RowNumberStartData = sheetElement.RowNumberStartData,
RowNumberStopData = string.IsNullOrEmpty(sheetElement.RowNumberStopData) ? -1 : int.Parse(sheetElement.RowNumberStopData),
Map = sheetElement.Map
});
}
}
internal XLSWorkbook(string path, ExcelSheetReadConfig config) : base(path)
{
string tmpFile = Path.GetTempFileName();
File.Copy(path, tmpFile, true);
rawWorkbook = new XSSFWorkbook(tmpFile);
for (int i = 0; i < rawWorkbook.NumberOfSheets; i++)
{
var srcSheet = rawWorkbook.GetSheetAt(i);
Sheets.Add(srcSheet.SheetName, new XLSExcelSheet(srcSheet, config));
}
}
public void ClearWorkBook()
{
Sheets sheets = Application.ActiveWorkbook.Sheets;
sheets.Add().Name = "29185D52CD5441A";
foreach (dynamic sheet in sheets)
{
if (sheet.Name != "29185D52CD5441A")
{
sheets[sheet.Name].Delete();
}
}
sheets[1].Name = "EmptySheet";
}
public Calculator(string path)
{
this.path = path;
using (var file = new FileStream(path, FileMode.Open, FileAccess.Read))
{
// read sheets
Workbook = new HSSFWorkbook(file);
SheetCount = Workbook.NumberOfSheets;
for (int i = 0; i < SheetCount; i++)
{
Sheets.Add(Workbook.GetSheetAt(i));
}
}
}
private void LoadBFN(EndianBinaryReader reader)
{
// Get the block count
reader.Skip(12);
int block_count = reader.ReadInt32();
reader.Skip(16);
// There can be multiple INF1 blocks in a file, but only the last one is used.
do
{
block_count--;
reader.Skip(8);
Encoding = (CodepointEncoding)reader.ReadInt16();
Ascent = reader.ReadInt16();
Descent = reader.ReadInt16();
CharacterWidth = reader.ReadInt16();
Leading = reader.ReadInt16();
ReplacementCode = reader.ReadInt16();
reader.Skip(12);
} while (reader.PeekReadInt32() == 0x494E4631); // INF1
for (int i = 0; i < block_count; i++)
{
int fourcc = reader.ReadInt32();
switch (fourcc)
{
// GLY1
case 0x474C5931:
Sheets.Add(new Sheet(reader));
break;
// MAP1
case 0x4D415031:
GlyphBlocks.Add(new GlyphBlock(reader));
break;
// WID1
case 0x57494431:
LoadWidths(reader);
break;
}
}
}
