|
I am writting software for my company in which the program needs to generate an Excel file without using excel. I've figured that part out by using the XML format for excel. However, I was wondering if there was a way to pring the files (preferrably sheet by sheet) without having excel installed? Or is there a way to convert the XLS files into a PDF? Any help in the right direction would be appreciated.
|
|
|
|
|
AFAIK, all the ways to read or work with an XLS files require Excel installed
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I was trying to install the setup of my program(VB.net 2005) on the machine which does not have the dotnet framework.
I have added the .net framework by right clicking the setup project- which is included in the project.
Add\assembly\browse\c:\installer-6171-19-Microsoft-NET-Framework-2-0-50727-English
then built it.
still getting the same problem .
u need to install the .net framework 2.0.50727
|
|
|
|
|
don't just add framework into your project, right click on setup project, select properties, click prerequisites and tick .net framework 2.0 and select install from the same location as my application option too. now build your project
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
i am doing the same thing now...... what u told .
adding the dotnet framework ...the following file.
should i just add it to the setup or i have to place it some where else as well.In order to run the setup successfully.because i am still getting the same problem.
I have checked the link as well
Download prerequisit from the same location as my application.
installer-6171-19-Microsoft-NET-Framework-2-0-50727-English
|
|
|
|
|
after building the setup project make sure you have .net framework redistributable in a folder inside your setup's release folder. if it is there then you are doing right. when you double click setup it will say the following prerequisites are not installed in your computer and will install when you press ok. thats the right way.
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
when you added your project output (the exe file from your program) visual studio will automatically add .net framework to your detected dependencies folder in solution explorer. make sure it detects correct.
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
When i am adding the project output , it does not confirm the .net framework dependency.I have already placed the .net framework exe into the debug and release folder.Still i am getting the sae problem.
Even i am using the two exe's
dotnetfx.exe
installer-6171-19-Microsoft-NET-Framework-2-0-50727-English.exe
|
|
|
|
|
How should I add an exe into my active project , When the same is demanding a COM component.
I mean can i add an exe into my active project????????????????
|
|
|
|
|
when you create setup project first open the project you need to create setup for. then from file add new project and then other project types and setup project. give the name setup and select add to current solution (you should not create a new solution). when setup project is loaded, on filesystem editor right click application folder and select add -> project output and select primary project output.
this will detect dot net version and prerequisites automatically. now you won't have to select dot net manually
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
How visual studio will automatically add .net framework to detected dependencies folder in solution explorer.
I have - in the prerequisite - checked the download prerequisites from the same location as my application.
I can't add the exe into the active project.because it is the COM component , dll not the exe which gets added into the references
Now what i have to do in addition to these to make the visual studio automatically add .net framework to detected dependencies folder in solution explorer
|
|
|
|
|
so you are using a .net setup project for deploying a non .net project ?
i didn't understand. don't you have a sing exe or dll created in .net 2.0 in your project ?
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
Hi.......
Is there any article that describes the setup wizard fo the following
Especially the View/Editor/User Interface , registry , file type , custom action , user interface , launch condition.
|
|
|
|
|
Hi,
I have to do updates to my mdb access database, which has 2 column, user_name and user_pwd.
I have followed the suggestion from MSDN, but I don't know it still got error when excuting update().It says "Update command" or "Insert Command" to have connection object...
Can someone give me some hints or point out to me that What I missed?
Here is my code:
<br />
Dim connStr As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\me.mdb")<br />
Dim sqlStr As String = "SELECT * FROM wpLogin"<br />
Dim dt As New DataTable()<br />
Dim dataAdapter As OleDbDataAdapter<br />
Dim ODBconn As OleDbConnection<br />
<br />
<br />
Public Function CreateDataAdapter(ByVal selectCommand As String, ByVal connection As OleDbConnection) As OleDbDataAdapter<br />
<br />
<pre>Dim adapter As OleDbDataAdapter = New OleDbDataAdapter(selectCommand, connection)<br />
<br />
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey<br />
<br />
' Create the commands.<br />
adapter.InsertCommand = New OleDbCommand( _<br />
"INSERT INTO wpLogin (user_name, user_pwd) " & _<br />
"VALUES (?, ?)")<br />
<br />
adapter.UpdateCommand = New OleDbCommand( _<br />
"UPDATE wpLogin SET user_name = ?, user_pwd = ? " & _<br />
"WHERE user_name = ?")<br />
<br />
adapter.DeleteCommand = New OleDbCommand("DELETE FROM wpLogin WHERE user_name = ?")<br />
<br />
' Create the parameters.<br />
adapter.InsertCommand.Parameters.Add( _<br />
"@user_name", OleDbType.Char, 50, "user_name")<br />
adapter.InsertCommand.Parameters.Add( _<br />
"@user_pwd", OleDbType.Char, 50, "user_pwd")<br />
<br />
adapter.UpdateCommand.Parameters.Add( _<br />
"@user_name", OleDbType.Char, 50, "user_name")<br />
adapter.UpdateCommand.Parameters.Add( _<br />
"@user_pwd", OleDbType.Char, 50, "user_pwd")<br />
<br />
adapter.DeleteCommand.Parameters.Add( _<br />
"@user_name", OleDbType.Char, 50, "user_name").SourceVersion = _<br />
DataRowVersion.Original<br />
<br />
Return adapter<br />
</pre>End Function<br />
<br />
<br />
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click<br />
<pre>'Displays the table's data in the data grid<br />
'Clear the current contents of the table<br />
dt.Clear()<br />
'Fill the data table with data from the database<br />
'Dim dataAdapter As New OleDb.OleDbDataAdapter(sqlStr, connStr)<br />
ODBconn = New OleDbConnection(connStr)<br />
dataAdapter = CreateDataAdapter(sqlStr, ODBconn)<br />
dataAdapter.Fill(dt)<br />
'dataAdapter.Dispose()<br />
'Display the table in the data grid<br />
dgDisplay.DataSource = dt</pre><br />
End Sub<br />
<br />
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click<br />
'Save the tables's changes back to the database<br />
<pre>Dim changes As Integer<br />
<br />
<br />
'Update the database with changes from the data table<br />
changes = dataAdapter.Update(dt)<br />
'dataAdapter.Dispose()<br />
'Display the number of changes made<br />
If changes > 0 Then<br />
MsgBox(CStr(changes) & " changed rows were stored in the database.")<br />
Else<br />
MsgBox("No changes made.")<br />
End If</pre> <br />
End Sub<br />
<br />
Private Sub UserManager_FormClosing(ByVal sender As System.Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles MyBase.FormClosing<br />
<pre>dataAdapter.Dispose()</pre><br />
End Sub<br />
End Class<br />
-- modified at 23:08 Friday 11th May, 2007
|
|
|
|
|
I have frame and listview1. I want to hide the frame when i click(left click or right click) on white area of listview1 where is there is no data (As shown in attched pic).could any one show me how this can be done?Thanks
<br />
Private Sub ListView1_Click()<br />
gstrSomething = ListView1.SelectedItem.SubItems(4)<br />
gstrSomethingElse = ListView1.SelectedItem.Text<br />
Frame1.Visible = True<br />
<br />
End Sub<br />
<br />
<br />
Private Sub ListView1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)<br />
<br />
Dim lvwItem As ListItem<br />
If Button = vbRightButton Then<br />
Set lvwItem = ListView1.HitTest(x, y)<br />
If Not lvwItem Is Nothing Then<br />
<br />
Frame1.Visible = True<br />
<br />
lvwItem.Selected = True<br />
PopupMenu mnuEdit<br />
Else<br />
Frame1.Visible = False<br />
End If<br />
End If<br />
<br />
<br />
End Sub<br />
<br />
|
|
|
|
|
have my program working but need to be able to search for files of multiple file types and search for multiple drives at the same time. Right now I can only search for one files type by typing the extension into a textbox. To search for the drive, i created a BrowseFolderDialog to search folder on a specific drive and the path is displayed in a textbox. So I have two question: Is there a way for me to search for multiple file types by typing the extensions in the textbox at the same time? Is there a way to search for more than one drive in a text box at one time?
Here is some code:
Private Sub GetDirectoryContents()
Dim FilePattern As String = "*." & TextBox2.Text.Trim
Dim sdir As String = TextBox1.Text.Trim
Dim dDir As New DirectoryInfo(sdir)
Dim fi As FileSystemInfo
For Each fi In dDir.GetFileSystemInfos(FilePattern)
ListBox1.Items.Add(fi.Name)
Next
End Sub
This is the class I created to search for the folders:
Dim MyBrowseFolder As New FolderBrowser()
Public Function ShowDialog(ByVal browseFolderTitle As String)
With MyBrowseFolder
.Style = FolderBrowserStyles.BrowseForComputer
.StartLocation = FolderBrowserFolder.MyComputer & .StartLocation = FolderBrowserFolder.MyDocuments
'Dialog box title
.Description = browseFolderTitle
.ShowDialog()
'Return the folder path.
ShowDialog = .DirectoryPath
jds1207
|
|
|
|
|
let the users type multiple extensions to a textbox seperated by commas. create a thread to search a specific extension in your path and then run multiple instances of that thread with one extension in each thread. since you have the code convert the function you are using to a thread
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
How do I create a thread?
|
|
|
|
|
|
Is this correct because its still not working?
Dim MyThread As New System.Threading.Thread(AddressOf GetDirectoryContents)
MyThread.Start()
It may seem simple but I've never worked with threads before.
|
|
|
|
|
Threading is a advanced topic to understand in a few minuts. i thing you should search in MSDN and a overall knowledge about threads and threads in vb.net first. then write your program, thread functions are not like ordinary functions, and when handling you should be more cautious because you may end up in thread locks. but threads are good practice if you want your program run in a faster way (by deviding the work load to multiple threads so you can get all the work done simultaniously)
jds1207 wrote: Dim MyThread As New System.Threading.Thread(AddressOf GetDirectoryContents)
MyThread.Start()
there is no problem with your code, what is the error you are getting ?
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
Error: Cross-thread operation not valid: Control 'ListBox1' accessed from a thread other than the thread it was created on.
Right now, when I do the file search I type the file type in the textbox(txt) and the files with those types are displayed in a listbox. I want to change it so I can type in for example, txt, bmp, log into the textbox and display all of those file types in the listbox together. Is threading the only solution for this?
|
|
|
|
|
you can't directly use the objects you created in your application inside the thread,
you can do your multiple extension search without a thread too, but you will have to search one by one extensions,but this will consume some time
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
I want to build an application in Visual Basic, integrating GIS technology which includes maps, and databases. I am a student who cant afford all the nice packages please help.
|
|
|
|
|
I wrote a GIS application in C++ for my final year project at university. Technology has moved on a lot since then and it would be much easier nowadays. So go for it. You can download Visual Studio 2005 Express Edition for free and that's all that would be needed.
If you want a head start you could look for open source GIS projects. I'm sure I saw one on CodePlex a couple of months back - that might be useful for you.
|
|
|
|