I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. How can I create a sample template using vb.net code?
View 6 RepliesI want to open a excel template with a browse button, the file needs to open and must be directly saved by the user. after the file is saved the file location needs to be displayed in a textbox.With this i can open excel itself, but i don't know how to open the template and save the document
Dim Xl As Excel.Application
Dim Filepath As String
Dim Workbook As Excel.Workbook
[code]....
The file opens and i get a save as dialog, but when i want to save the document it doesn;t save at all, However it won't give me a error.
In VB.NET,I want to create template at runtime and save it the template with name. for ex : Administrator design a page with 5 fields like using firstname, lastname, dob,nationality and job. He want to assign this page to the user with some restriction like user1 need to enter the all the fields and save it the forms as user1profile, but user2 need to enter only firstname and lastname and save it as user2profile.(in features, he can remove the fields from the form).
View 1 RepliesI'm working with a vb.net application and i automate word with vb.net. so i want to create a page based on my template so i have to specify where the template file is but in my computer the file is in a special folder lets say named myapps but in the clients file it will probably be in the programfilles folder is there a way that i must not specift the whole path and just the file name or something like that?
View 1 RepliesI have an application that I'm writing that needs to allow the user to be able to create templates and save them for how the applicaton will work. For instance, lets say I am provisioining mobile devices, and my application allows the user to create a template to only install "application1" on the device, with "application1" settings for "devicetype1". But then if the user has "devicetype2", he or she can select the template that they created to install the software for that kind of device. I've looked around and all I find is the .exe.config for read only application settings, and I have found the user.config for the read/write variables. But that won't work as my application could have several templates depending on what the user chooses. I'm looking to have my app have a "create template", "edit existing template, and"use existing template" buttons, and have my config file extension like *.ipx for example.
View 1 RepliesI would like have a progress bar like Outlook 2007. when you click on a link in a message. you can see a progress bar between the ribbon menu and reading pane in outlook 2007.
Is it possible to have the same progress in Excel 2007?
i need to generate an excel sheet from an excel template which contains drop down lists. I need to use the template and populate the with data from datbase and select the appropriate value from the drop down lists and generate the new excel sheet.
View 2 RepliesI found this code snippet made with c# OK, let's say I have a PDF document called "Form.pdf" with 4 form fields. The form fileds are "name", "address", "postal_code" and "email".Here's the code to create a new PDF file using "Form.pdf" as a template:
private void fillForm()
{
string formFile = @"N:.NETForm.pdf";
string newFile = @"N:.NETFilled-out Form.pdf";
[code]....
I managed to export my data to an excel file, by using a excel template that I created beforehand. But I'd rather have that the excel file will be create when I press the button instead going to my file.
Dim ApExcel As Object
ApExcel = CreateObject("Excel.application")
ApExcel.Visible = True
[Code]....
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 maintain the format of the original template. I've recently populated a word document using merge fields... does excel have anything similar? Could I break the file down into XML and use that as a template?
View 1 Replieshow can I create an excel file in excel 2003, open it, add workbook, write into it, save it and close it by visual basic 2008.
View 2 RepliesIs there a way in VB .NET to create an Excel file without having Excel installed?
View 7 Repliesi make my textboxes to export data into an excel template....it works fine but there are few errors too..but i don't know how to fix it...here is my code.
Dim objExcel As Object
Dim objWorkBook As Object
Dim objWorkSheet As Object
[Code]....
for the objworkbook.SaveAs,it will always ask me to replace to file and i would like to use SAVE command...bu it not works..anything happen?sumore everytime i run this process,it will tell me the file is read-only while the setting doesn't shows that the file is read-only...and i have to go to task manager and end the EXCEL process by myself to run the process again
I need to port a VBA app to VB.NET, there is only one problem excel won't save my template. Excel opens the right file and it shows me the save file dialog, only one problem it won't save any file, however it won't give me an error but won't return me the file path because it doesn't save the file anywhere.
[Code]...
I have attached a printscreen version of my excel template here,
Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database.
I can't get this to work. My program fills all the values into an Excel spreadsheet- no problems there. What I'd like to do is a print preview/print function. I can't seem to get my code right, all I get are blank pages in the print preview box.
Dim oExcel As Object = CreateObject("Excel.Application")
oExcel.Workbooks.Open("C:DailyLogsDailyLog.xlsx")
PrintPreviewDialog1.Document = PrintDocument1
PrintPreviewDialog1.ShowDialog()
oExcel.Sheet1.PrintPreview()
So as I see it, this should open excel, then navigate to the actual excel file. The print preview dialog should come up, which it does, and the excel sheet1 should be previewing, but it's not? I don't have any errors, just a blank print preview. At least thats how I see it, but obviously I'm wrong because it won't work.
I have a template in an excel worksheet. I can successfully insert data into the worksheet and print it out with backend coding.
The problem I am facing is, the reverse empty space for the header and side is too much.
Is there any possible way to reduce the empty space?
Using NPOI and attempting to follow a tutorial here: [URL]..I'm coming across an "Object reference not set to an instance of an object" error at this line: sheet.GetRow(1).GetCell(1).SetCellValue("some test value")
when trying to use this code:
Imports System.IO
Imports System.Web.Security
Imports NPOI.HSSF.UserModel
Imports NPOI.SS.UserModel
Imports NPOI.SS.Util
Imports NPOI.HSSF.Util
[Code]...
Yet the question is still open...why didn't the code in the first example work? Do you have to declare every new row of data? What happens when you have lots of rows of database data?
I need to open a .xlt for editing, like so:
System.Diagnostics.Process.Start("Template.xlt", "Editable=True")
But I don't know the correct switch in Excel. This is the same as right-clicking on an .xlt and choosing "Open", whereas the default action is "New".
I get the following error message when I try the following:[code]"Excel cannot open the file 'ContactReports.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."What I would like to do is Open a excel file that is the XLTemplatePath and the either rename or save the file at the XLSaveReportPath and then use that renamed/saved file to fill the report out.I am using Visual Studio 2008 in VB.NET
View 2 Repliescreate a Class Template for VB so that when I click Add -> Class, in the Add New Items window, that class will be displayed? And also the variables that are needed inside the class. I guess I need a tutorial.
View 3 RepliesForgive me if this has already been covered in a previous post. I am considering using VB.net for a project but need to know before I dive in if it can perform this particular functionality. The application I wish to develop would need to be able to create html and email templates using variable tokens - what I mean is that users would need to be able to insert into their html or email template previously assigned variables that would send dynamically generated text from the database - so, for example, they could write in their template {title}, or {firstname} {lastname} which would then be replaced by the data from the db.
View 3 RepliesI downloaded and installed the xml to schema tool for VS 2008. No problems. But no template in Vsiaul Studio.
View 3 RepliesHow do I create a Windows form template? want to avoid adding all graphics setting up all other objects each time I create a new form. I am sure there must be an easy way of doing this but I just cant see how.
View 7 RepliesI am designing a form that will create a template of data that will later be loaded into another form.From a menu command "Create New Template" I will need to ask how many Fields will be needed for the new template in an input box. If the user would input say 10, then I need to generate 10 labels, 10 text boxes, & 10 combo boxes. Each group (label, Text Box & Combo Box) on its own row on the form.I also want create the data mapping for each of them at this time.Once I have achieved this then I will add a form that will lookup the template name, and row count given from the above form via the database and load the required rows of items for further data entry.
Since I will have a MAX row limit I thought about designing a form using a Table Layout panel with 25 Rows and 5 columns then doing some sort of .visible true/false for the layout panel row after the user input of row/field quantities.Another question is resizing the form around only the visible rows.
I am using VB 2008 Express Edition and I need to create applications using the Smart Device template and the ASP.NET Web Site template.
View 1 RepliesSELECT * INTO [supplierexp] FROM [supplier] IN '' [ODBC;Driver={SQLServer};Server=(local);Database=sh op;user name='shop';password='abc123';Trusted_ Connection=yes];"For above code im getting error like ODBC--connection to '{SQLServer}(local)' failed. Im using the valid username and password only.How to remove the error
View 1 RepliesI want to create an excel spreadsheet but, I want it to prompt me for the file name and where to put it. Once it is opened, I know how to interface with it. I only need to create a new file with a prompted for filename and location.
View 1 RepliesI'm trying to allow users to add a volumetric sheet to an existing excel spreadsheet. I need it to check to see if the requested tab name currently exists and if not then to create the sheet and be able to populate it with the proper information. Also, how do I reference back to the active worksheet once it is created.[code]...Create and name a new worksheet within an excel file?
View 10 Replies