I have a vb.net app that I create an excel file with from sql data. It creates it fine but for cells that have a social security number, it makes that cell numeric and removes the leading zeros. Does anyone know how to force this cell as a string when adding it to the worksheet? Is there a property or method I can call to do this in my vb app?
View 1 Replies
Here is my situation.
data = "" & data & ""
xlsheet.Range(crange).Value = data
xlfile.SaveAs(FileName:=finalfilename, FileFormat:=6)
This code puts " around the data, puts the data in the range and saves the workbook(xlfile) with one worksheet(xlsheet) as a csv file.
If I open the csv file in notepad I find these following
1.quotes are removed
2.leading 0 from numbers are removed
How to ensure that quotes are present while saving the file programatically?
i need a vb8 code to open a txt file,search for a string in it & extract string in a excel file.
View 2 Repliesi want to make a custom file type like "abc.xyz" which should have all the attribs of a directory like
moving other files and folders to it, open, close, delete, create new, etc... in vb.net or c#.net
I have this peace of code, where I want to make an excel file:
Dim filename As String = ""
Dim sheetname As String = ""
Dim xlApp As Excel.Application
[Code]....
The problem is that this only works if the file and sheet already exists. How do I create a new Excel file?
I have been working on a very advanced feature that will allow programmers to right object that spit out other objects. Code that writes code. However, I have run into a problem. I use a file type that specifies to the coding parser how to create the object that is going to write the objects. Example, the Programmer writes a "NTF" file which contains code switches and variables that the Computer will parse and create a "Template Object" that the programmer can include in his project and call to generate the code objects. I'll right a object that creates an ASPX page for each table in my database, and I'll then call that object against my database. It's pretty straight forward. This "NTF" file has special parser commands, and uses VB.NET to manipulate the output based on the variables that come into the object. The problem is I would like to have an editor just as advanced as Visual Studio to recognizes the custom parser commands and the VB.net code. At the very least, something that formats the "NTF" file and integrates into Visual Studio.url...
View 2 RepliesI am creating an excel file in my vb app. Below is the code I am using to do this. But when the application is closed, I still have an instance of Excel running in the background. How do i close it? I can do it with the xlWBook but not the xlApp.
'create empty excel file
xlApp = CType(CreateObject("Excel.Application"), Microsoft.Office.Interop.Excel.Application)
[Code].....
I am trying to use the BGW to save a DGV to excel file, but don't know how to do it correctly, specifically setting the savefile name this code doesn't work gives me:
'System.Runtime.InteropServices.COMException' occurred
- Make sure the specified folder exists.
- Make sure the folder that contains the file is not read-only.
- Make sure the file name does not contain any of the following characters:
Ensure that your Main function has STAThreadAttribute marked on it. This exception is only raised if a debugger is attached to the process. I also tried doing the Save in the BGW RunWorker Completed event but then there is no file name. It seems I need to pass the file name the user inputs in the SaveFileDialog to the BWG WorkerCompleted event somehow
Private Sub excelexp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles excelexp.Click
ProgressBar2.Visible = True
Saving.Visible = True
Dim saveFileDialog1 As New SaveFileDialog()
[Code] .....
I need my app to create a excel file, but I am getting a error running this code. While running this in debug, on the line "xlWorkSheet.SaveAs("C:vbexcel.xlsx")" there is a error saying "ComException was unhandled" and "Exception from Hresult 0x800A03EC"
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object,_
ByVal e As System.EventArgs) Handles Button1.Click
[code]....
According to the General Naming Conventions the usage of CLR type names (e.g. String, Int16) should be preferred over the usage of language specific type names (string, short). I usually follow this advice. Resharper however seems to use the language specific type names when generating code (eg. when extracting methods or generating foreach loops) which is very annoying.
View 2 RepliesI have a text box labled QTY, which feeds the QTY column on a datatable. the table then is ran through a function that takes the data and converts it to a string which my production machine can read. My problem is this, and its probably really simple (these problems usually are) how to i force the user to use a specific type of input on the txtbox so they would have to put the QTY in the format of 01 02 03 etc etc, i have it set to default to 00 but i want to force the user to haver to input 2 chars.
View 5 RepliesApplication using ado.net
When reading data from an excel file the driver tries to detect the data type of a column based on the contents of that column.
Once it's decided on the datatype then data that is not compatible with that datatype is simply ignored and returned as Null when you read that column using ado.net
For example if most of the column contains numbers then the occasional cell containing non-numeric data is returned as null.
Is there a way to force it to always return all data as text no matter what the actual column contains. ?
I am using decimal numbers to be able to sort correctly in Excel; however I want to have a column where they are displayed as fractions. I have made a function to convert them to fractions as text ( 1.625 converts to "1 5/8 dia."). I would like to make the 5 superscript and the 8 subscript. I can do this manually by highlighting the number and formatting, but I would like to do this in code.
View 1 RepliesI am using :
Dim di As DirectoryInfo = New DirectoryInfo(My.Settings.Outgoing(CreateFolderTextBox.Text)) to create a directory
[CODE]......................
But I get the following error: Conversion from string "testfolder" to type 'Integer' is not valid.
When I look at a file on my hard disk, e.g. test.csv, when I look at the Properties of the file, it is officially known as, "Microsoft Office Excel Comma Separated Values File", and file types of .pdf are listed as "Adobe Acrobat Document", etc. etc. All of this information can be seen in Windows Explorer too when my folders are displayed by Details. How do you get at this "type of file" information with .NET?
View 2 RepliesPublic Months() As String = {"January", "February", 'March", 'April",
"May","June", "July", "August", "September","October", "November",
'December"}
[code]......
How can I generate XML directly into a string instead of creating a xml file?
View 3 RepliesI am trying to open an Excel file using the following commands:
xlsWB = xlsApp.Workbooks.Open(filename, , True)
where 'filename' is the name of the file.However I am getting the following error message:
Message = "Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"
I originally developed an application where I used the above code with default language setting of "English" (under regional and language settings). When I am changing the language setting to "French", the above errror comes up. I am changing the language setting to French in order to simulate an error when this application is run in a French version computer.
I am having a bit of trouble converting a single stored in a string as four hex values. I believe my problem stems from some Unicode hex values not matching the corresponding ASCII hex value above 0x7F (127). For example, I have the following single stored in a string; "518.42" or 0x44019AE1. The char that would contain 0x9A if the data type were ASCII contains U+0161 which will not convert properly to a byte array. My question is: Is there any way to force a string to be of ASCII rather than Unicode? Or maybe there are other recommendations? For reference I have tried both of the following. The first throws a format exception and the second converts to the wrong single.
Private Function ConvertHexToSingle(ByVal hexValue As String) As Single
Try
Dim iInputIndex As Integer = 0
Dim iOutputIndex As Integer = 0
[code].....
In VB6 if you do this,
keyStr = Left$(baseKey + encPassword, 56)
the string will be 56 characters even if it means appending whitespaces to the end.
in VB.NET
keyStr = Left$(baseKey + encPassword, 56)
will not necessarily be 56 characters. How can I force it to append whitespaces at the end if the baseKey + encPassword is less than 56 characters long?
I've tried searching and haven't found much useful information on this, I know it has to be possible, but I'm not sure how. I've got an application that bi-directionally syncs with an SQL express 2008 server. right now, I've got a hardcoded sa user in my conection string, however one feature that was asked for was to audit every change made by end users into the database. To implement this, I've created a user login and password for each user that is going to use my app (8 of them) on my sql server, however I now need to change the connection string to include each users name in the string. This is what I've got setup so far:
[Code]...
I'm having a problem with converting from one source type to a destination type. I have a form with 2 buttons (button 2 uses the OpenFileDialog to have the user open an excel file set to NewFile),(button 1 takes the contents from specific cells in NewFile and arranges them how I need into oXLApp1).
The error I get is "Unable to cast object of type 'System.IO.FileStream' to type 'Excel.Application'." in line 14 of the code below.
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]....
i am trying to read an existing excel 2007 file from vb.net i used a form with single button and i written code in button click event code is :[code...]
View 1 RepliesOkay, I was doing a lot of research this morning and found what I hope to be a promising example (code and installation file in the zip folder I downloaded). Even though it is from 2005, and I am working with 2010.I had to update/upgrade the entire project to view the code, and... ok, I am just rambling.I know how to set the filters for SaveDialog and OpenDialog (took me a long while to understand, but I now understand it), but when I finish and build the project to host it on CNet Download or somewhere similar.
View 3 RepliesHow to read an Excel file without using OLEDB connection string?
View 2 Repliesplease tell me what is below code doing? is it creating array with two values or its creating to string index which will take value later? [code]
View 4 RepliesI'm in the process of porting an old excel addin that was writen in VBA to VB .NET. The Excel addin interacts with a number of external com objects. The code sorta looks like this:[code...]
What I'm trying to do is read the string from the COM object and get it in durr for use later in my program.
That second line results in the exception posted above. If I try casting with CStr/CType I get the same exception.
The visual studio watch window reports the type of hurr.getString as a "System.__ComObject" whereas the VBA watch window reports the type as "Variant/Object/String".
Microsoft.VisualBasic.Information.TypeName(hurr.getString) says the type is "String".
my code is :
[Code]...
The error is Value of type '1-dimensional array of string' cannot be converted to 'String'.
I am using the following code to copy a file:System.IO.File.Copy(strOldFile, strNewFile)
But the trouble is that the newly-created file inherits the old file's timestamp. Is there a way to force the timestamp to update?
I want to prompt users to save file instead of opening file in application. For example if user click a mp3 file link....mp3 file must not be open in win media player...instead user promoted to download that file.
View 2 Replies
