C# - Convert XLS To XLSB Programatically?
Jun 22, 2011
I have a customer that needs to convert XLS files to XLSB. Has anyone done this programatically, (with or without an add-on --- doesn't matter --- just need to be able to automate it)? I'm looking for a way to automate this.
As a side note, the customer is asking about this because they use Sharepoint, and it seems it has a way to analyze XLSB files quicker and easier than XLS??? I'm working to improve my Sharepoint knowledge, but in the meantime, I'm trying to find an answer to this XLSB issue.
View 2 Replies
ADVERTISEMENT
May 26, 2010
How can I download a pdf and store to disk using vb.net or c#? The url (of the pdf) has some rediection going on before the final pdf is reached. I tried the below but the pdf seems corrupted when I attempt to open locally,
Dim PdfFile As FileStream = File.OpenWrite(saveTo)
Dim PdfStream As MemoryStream = GetFileStream(pdfURL)
PdfStream.WriteTo(PdfFile)
PdfStream.Flush()
[Code]...
View 2 Replies
Mar 4, 2010
I have a .NET dll which I use from a C++ program. Now I have to register the dll programmatically on a deployment computer. How do i do that (programmatically! not using regasm)? I remember, when I once called a VB6 dll from a C++ dll, I had to use DllRegisterServer and DllUnregisterServer. Is that still so with a .NET dll? It seems I have to somehow add the dllregisterserver function to the .NET dll.
View 3 Replies
Dec 26, 2011
Me.StuDetComboBox.DataSource = StudentsDet.BindingSource
Me.StuDetComboBox.DisplayMember = "StuName"
ComboBox Bind Programatically Like Above Right ?
View 8 Replies
Dec 11, 2010
I'll try to make this simple, using VB.Net on Windows Vista:How do you change key bindings programatically?I'm thinking it has to do with the registry so if it does just give me the registry key names(i know how to change the registry already)If it helps, the reason I want to do this is to change the Windows media center button so that it opens my program rather than WMC.
View 3 Replies
Oct 25, 2011
I have a window form and a ComboBox is placed on that form. I want to open combobox programatically on keypress event.
View 14 Replies
Dec 14, 2009
I'm working on a script in vb.net windows application and I need to import a table from one access database into another access database. I wanted to know if this was possible to do w/ out having to create the table and then loop through all the records to insert them into the table? In other words, is there some method that will allow me to import the table dirrectly as it is?
View 5 Replies
Jun 18, 2012
I've written an interface with a 3rd party web service in VB.NET. The final step in that interface involves the 3rd party delivering to us (as a stream) a PDF document. After streaming is complete I save a copy of the PDF on our servers, so that our users can view the PDF by clicking on a link in our system. The PDF opens fine in Acrobat X, but when I try to open it programatically I an error saying that "the file is damaged and could not be repaired". I can also open the file in IE just fine, with no issues, and the same code that displays this PDF works just fine on lots of other existing PDFs that predate the 3rd party interface.
I have emptied out temporary internet files as suggested in some posts I saw online. I also opened the PDF in Notepad++ and the %PDF tag is first, and the %%EOF tag is last, so there's certainly no corruption visible in the document source that I can see. Below is the (very standard) code we use to open PDFs into a separate browser instance on our site:
PDFFile = System.AppDomain.CurrentDomain.BaseDirectory & Request.QueryString("LetterPath") & Request.QueryString("Letter")
Response.Clear()
Response.ClearHeaders()
Response.BufferOutput = True
[code].....
View 1 Replies
May 16, 2012
I am reading values from a database (boolean) and if true, I want it to check a checkbox,and if false, keep the checkbox unchecked. The lines look like this: blEnergy.Items.FindByValue(1).Selected = track_usageIn this case, track_usage is a boolean value.This way does not actually create the check mark in the checkbox like I wanted it to. What is the best way to do this?
View 1 Replies
Oct 28, 2011
im trying to find a better way to end the application im working on right now programatically, sometimes a user simple wants to end it all and since in the properties of my project the program is set to only end after all forms have been closed, (oddly enough i close all forms and it still is executing so i use dispose method and then end) what would be the best way to end the application and free pc memory for everything attached to it? i use:
form1.dispose()
form2.dispose()
form3.dispose()
me.dispose()
End
as ive readed online, end simply stops the app and nothing else, which makes me think, does its data still persists in the ram? i want to clear everything and not leave useless resources anywhere.
View 3 Replies
Oct 9, 2009
I am trying to write a small app that searches the GAC for a dll. I have been trying to get this done but can't seem to find any resources online. I am using VS.Net 2008.
View 3 Replies
Oct 7, 2011
I'm trying to find a good VB.net example of setting a LaserJet to Duplex.
View 1 Replies
Feb 1, 2012
how to use the TIFF IFILTER programatically.
I just want to call it from the command line like this and get the OCR'd text back.
myprog filename.tiff
The windows 7 SDK has FILTDUMP which isn't source supplied, and anyway, when I use that I get
0x80004005
even when running as admin -
View 1 Replies
Oct 4, 2007
Is there a way to programatically determine if the OS Architecture is 32-bit or 64 -bit?
View 5 Replies
Sep 22, 2009
My VB.NET (3.5) application generates Excel reports. Newer versions of Excel support the Office Open XML file format, while older versions don't.
I'd like my application to identify which version of Excel is installed on the local machine, and use a different method for generating the report (Newer versions: by generating an XML file. Older versions: by utilizing Excel Automation).
How can I identify the Excel version installed on the local machine?
View 4 Replies
Mar 9, 2009
Using <System.ComponentModel.TypeConverter(GetType(System.ComponentModel.ExpandableObjectConverter))> _
on the declaration of a class (which is a property of another class) that consists of a number properties.
I load an instance of this class with simply ...
PropertyGrid1.SelectedObject = oColumn
Obviously I don't want to manually build the propertygrid in code, I know how to do that.
But here's the problem. Depending on the value of a property, certain other properties should not be visible, as though I'd used the <System.ComponentModel.Browsable(False)> _
attribute on the property declaration.Is there anyway to do this programmatically, without having to handle all the building of the property grid manually>
View 3 Replies
Nov 26, 2011
If I have a form called index.aspx and I want to set the background colour programatically how do I do such a thing? Like if I wanted to set the pages background by calling a method called Changebackground? [code]
View 1 Replies
Nov 27, 2009
Is there a way to do it in c# or vb.net? I have to bring a system out of standby and play a notification sound if it is in standby mode, at specific time intervals.
View 3 Replies
Jun 25, 2012
There is a website which has 4 web pages . On first page there is a button, On 2nd page there are also some buttons, on 3rd page there is also a single button , and 4th page also contained a single button. Problem is that my code programatically clicks the button of first page 2nd page and 3rd page . But is is not clicking the button on 4th page programatically.[code]
View 1 Replies
Sep 15, 2010
i am trying to generate an HTML file from VB.Net 2005. Basically, I want to create a file that is a representation of a SQL query from a database in a table, then save the resulting HTML file to a location.I have got my code mostly working, but am in the process of fine tuning the formating of the HTML code.
[Code]...
View 2 Replies
Feb 15, 2012
how to create tables at runtime? Or if it is a long story, kindly direct me to a site where I can learn more...
View 8 Replies
Jun 5, 2009
I have a datagridview named "DG" bound to a datatable. The grid has one column that requires me to determine its value, so the grid has the virtual mode property set to true.When i try to add using the dg.rows.add, i get a message saying 'operation not valid while in virtual mode'.If i set the virtual mode to false and execute the dg.rows.add line i get."Rows cannot be programatically added to the datagrid's rows collection when the control is databound"Ok....i cannot use rows.add when in virtual mode,.....and i cannot use rows.add when i am in data-bound mode.So then next thing i try is ctype(dg.datasource,datatable).rows.add , This gets the row into both the underlying table as well as the into a new row located at the bottom of the grid.
I try this: dg.sort(dg.columns("Row"),ascending) and get this "Operation is not supported when VirtualMode is set to true." i try seting virtual mode to false and get this: "Data-bound DataGridView control can only be sorted on data-bound columns."The column "Row" IS a column in the underlying table.If i click on the column header it sorts correctly.All i want to do is add arow and have it be located in the correct place in the sort order.
View 3 Replies
Feb 12, 2012
I'm obviously looking for the wrong thing, every reference I find points me back to VB scripting.I want to be able to create a set of shortcuts to various files, within a user selected folder, programatically in VB 2005.
Searching on "links", "shorcuts" all take me in circular fashion back to WshShell ... can someone please point me toward some VB / .NET code
View 10 Replies
Sep 1, 2009
How to execute the DB2 commands programatically for Backup..Here are the commands that need to be executed for DB2 Backup.I am using IBM.Data.DB2 namespace, And as soon as we connect to Dbase in step 2 it crashes to QUIESCE.
1.CONNECT TO <DataBase Name>
2.QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;The Exception Message I am getting [code]
3.CONNECT RESET;
4.BACKUP DATABASE <DataBase Name> TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
5.CONNECT TO <DataBase Name>;
6.UNQUIESCE DATABASE;
7.CONNECT RESET;
View 1 Replies
Mar 22, 2012
I need to write a monitoring/watchdog program to check a series of application..The monitoring program should be able to Determine whether the applications it is monitoring has hang or no response If it hangs, restart the specific application.What sort of API in VB.NET can help me achieve this?
View 2 Replies
Aug 4, 2010
What I want to do is use one PC to test an application on another on the same 19.2.168.X.X.I would like to make it seem like SOAP requests are coming from a variety of different PCs, just to make the applciations log file easier to read and I have been told that virtual IP Addresses are the way to go. So, how do I defien a range and then use them one by one in VB? (I guss that this is effectively IP header spooging?)
View 2 Replies
Sep 4, 2011
I'm having some issues when it comes to installing a certificate to specific stores without any user interaction.
View 3 Replies
Dec 31, 2010
I want to ask if its better to make datasets with wizards or programatically. Im studing with a teacher that works programatically ... but its a lot of coding. so, retrieving data is faster when you write code or is the same using wizards on datasources?? when you use datasource wizard , it open and close conections automatically?
View 4 Replies
Oct 22, 2010
I am trying to add formatted text to a rich text box..For instance, I want to add a heading as bold ("HEADING: ") and some data after it as regular ("REGULAR Data")...then a new line and do it all over again.
first name: blah
last nem: blahh
etc...etc...
I'd like to have a couple functions to perform the action.When I use the below functions to add txt to a single rtf box, I get lines in either all bold or all regular. It doesn't seem to keep the font formatting after it adds text..
[Code]...
View 1 Replies
Aug 23, 2010
I have a textbox that i've bound to a dataset via the IDE.i've but when adding a new record i can;t populate it programatically, but the user can type data into. The follwing code doesn't put the required text in the textbox, but i can type it it while debugging:
FQuoteCard.QuoteHeaderBindingSource.AddNew()
FQuoteCard.TextBoxBurdensOperatorID.Text = "some random text"
this doesn't seem to make any sense - i'm adding new so i should be able to populate the textbox programatically, in the same way as a user can type in the textbox.I suppose i can bind the textbox programatically after adding the text, but this somewhat defeats the object of being able to databind via the IDE.
View 5 Replies
