Stack Overflow
Stack Overflow

Questions tagged [excel-template]

32 questions
9
votes
2 answers

Creating excel sheet from template in Java, new versions of Excel

I found the following code to create a excel sheet from an existing template with formats and add data to it and save it to a new file POIFSFileSystem fs = new POIFSFileSystem( new FileInputStream("template.xls")); HSSFWorkbook wb = new …
cma3982
  • 91
  • 1
  • 1
  • 3
9
votes
1 answer

Using Excel sheet as a template vs. a "real" Excel template in OpenXML

Does anyone have any good answer what kind of difference there is between using some arbitrary pre-formatted Excel 2007 *.xlsx file as a template, loading it in my C# app, and filling up some of its cells with data using the Microsoft OpenXML SDK…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
4
votes
4 answers

Finding an Excel Spreadsheet's template path

I have an Excel spreadsheet template with VBA code (an 'xltm' file). I want to find the path of the template in the spreadsheet that is opened by the template. Example of the problem: A user opens a new spreadsheet from the template file in 'C:\My…
James R
  • 141
  • 2
  • 14
3
votes
2 answers

How to change Excel 2013 Template Miniature

Is there a simple way to change / replace the automatically generated Template Miniature with a different image.
Jesper Storm
  • 31
  • 3
3
votes
1 answer

Prevent Excel from refreshing Pivot Table until told to do so by VBA

I have an Excel Template (.xlt) that contains a Worksheet for report data, and 4x Worksheets with Pivot Tables. When our reporting system creates a report and applys the template to it, some of the fields referenced by the Pivot Tables don't exist,…
David Gard
  • 11,225
  • 36
  • 115
  • 227
2
votes
1 answer

Temporarily set default file type in Save As dialogue Excel

I'm making a template for macro addins in Excel. Addins have this weird thing that when you close them Excel won't prompt you to save. So I want all my addins to inherit from a template with this code: Private Sub Workbook_BeforeClose(ByRef Cancel…
Greedo
  • 4,967
  • 2
  • 30
  • 78
1
vote
1 answer

How to fill an excel template using ASP.NET, VB or C#?

I have a an excel file that has been manually populated, and now needs to be automatically populated using ASP.NET, vb or c#. I've been looking around, and have found examples on how to export a gridview, and data to excel sheet, but not anyway to…
Michael Armstrong
  • 371
  • 1
  • 5
  • 16
1
vote
2 answers

Excel SUM current column (via Excel::Template)

I'm using Excel::Template to generate a series of Excel files via perl. However, I need to do a SUM function on the current Column. I know I can do =SUM(3:15) but that gives the sum of ALL columns in rows 3-15. Is there an easier way to do what I'm…
Glen Solsberry
  • 11,960
  • 15
  • 69
  • 94
1
vote
2 answers

Aspose Cells Java - Insert Row to Excel Table

I'm new to aspose cells. I've a template excel file that has a simple Data Table (with a header row and one empty row) and a bar chart (with the data table configured as source). With aspose cells version 8.1.1. i'm trying to read the excel file,…
Kathir
  • 27
  • 7
1
vote
1 answer

VSTO pre-populated template available via AddIn

I'm new to VSTO - while within Excel, we would like the user to click on an Excel AddIn icon, to get a template of headings, formulas, colours/fonts, etc. Is it best to create this via a VS2010 "Excel Template" or "Excel AddIn" project? Note that…
Travis Ingram
  • 387
  • 5
  • 21
0
votes
1 answer

How to delete all Command Bars in Excel 2007 template .xltx and add own command bar with own controls?

I use VS 2010 for creating Excel 2007 xltx template. I want to remove all Excel command bars and disable to show them users and add own command bar with my controls. And in some controls I want to call VBA function that will be in this template. I…
amaranth
  • 979
  • 2
  • 22
  • 40
0
votes
0 answers

Excel template in JasperServer

I've created a report which uses excel template for export to xls. It' works well in JasperStudio. But I got a trouble when tried to publish it to jasperserver. I got an error file not found for my template. Excel template was loaded to the same…
alexey pelevin
  • 11
  • 1
0
votes
1 answer

How to display custom text as a label in an excel cell for a particular column?

I want to create a custom template for users with data validations. I have completed the data validation part but I want to display all the cell values in a certain columns as dropdown values with a label like "Select from dropdown".
khaja sheriff
  • 1
  • 2
0
votes
1 answer

Repeat Column Headers in BI Publisher Excel Templates in fusion

In fusion BIP report, when data in excel template exceeds 65536 rows it gets splitted into multiple sheets. I have a requirement to repeat column headers in BI publisher excel templates when the data split into multiple sheets. For every sheet…
ann 14
  • 1
0
votes
1 answer

How to make a field (column value) span multiple rows in Excel Templates to be used in Oracle BI Pub Reports?

I am creating an Excel Template for BI Pub Reports, Sample XML is generated using Oracle BI Pub Data Model. My Data Model is like this :- My sample XML is here:-