629 Topics
 | |
| | Hello guys, I found a lot examples about this one but I still don't have it all working. So the thing is that I have a button in my C# web application called Export to Excel. The functionality should works as if the button is clicked - it just simply … |
| | Hi, I am having an issue with updating my database with info from an excel spreadsheet. I am using php-excelreader from: [url]http://sourceforge.net/projects/phpexcelreader/[/url] Here is what I have thus far: [code=php] <?php require_once 'reader.php'; $Host = "..."; $User = "..."; $Password = "..."; $DBname = "..."; $Link = mysql_connect ($Host, $User, … |
| | Hello everyone! I need to anticipate that I am very new to the Microsoft developing world, therefore I am not confident with Visual Studio. I need to write an application for a windows server that works with excel. Looking on the web I found that the best method would be … |
| | hi, i'm using an excel add-in which creates protected sheets where i can select options in different controls (like listboxes). I need to have a process run at intervals but this option is not included in the add-in. The process is initiated by selecting "Starts" from a listbox. Is there … |
| | Is it possible? Currently, I am inserting data to a CSV file using PHP via the fputcsv() function. When opened in Excel, it works fine. The problem is that all the columns are of the default size. Is there a way to autofit the column width and possibly modify the … |
| | hi, i'm using winwedge to link up a balance to a computer, in order to gather the readings into an excel sheet. i've writen the code that starts winwedge at the press of a button, and created the macro that is supposed to request readings and send them to the … |
| | hi i need to make an excel macro that handles serial communication and takes data from two lab balances. I've looked around and found that i can use xmcommcrc or winwedge (others too but these i'm experimenting with). The result should be that data would be recorded live into an … |
| | hi i'm making an excel worksheet that will generate some random numbers. i used this formula: =RAND()*(High-Low)+Low, to generate a number between 0 and some other value and then subtract that from another number. Like this i obtain random variations around a value(just lower than the original). However, i need … |
| | if a file that has multiple columns, like [CODE]1 7 3 8 5 6 3 4 5 6 7 8 1 7 6 4 4 3[/CODE] i want to read the first row and see if there numbers that are grater than 6. Then add that number to all the …  |
| | Hi all, In a program I've been working on I would like to start a process and save it in a variable of type Process. This is so I can kill it later, if needed, and change the window type. The process is an Excel document. Here is some relevant … |
| | I have the code to parse data to a Datagridview and then export that into an excel spreadsheet. How can I export the headers of the datagridview? [CODE] var bs3 = new BindingSource { DataSource = query }; dataGridView1.AutoGenerateColumns = true; dataGridView1.AutoSize = true; dataGridView1.DataSource = bs3; } } private … |
| | The below bit of code is running very very slowly. I cant see why this should be but there seems to be almost a second delay when I'm using f8 to run through the code bit by bit when I get to the end if...any clues? [code] Sub firstResponse() Dim … |
 | Very new to writing macros, trying to impress the boss with a project, but I am stuck with a code. I can hide the rows when the checkbox is selected, but the other checkboxes are still visible. Is there a way to hide other checkboxes as well. My current code: … |
| | I have a project where I need to retrieve data from MS SQL Server and format it into an Excel Spreadsheet. I am using the OfficePartner component to try and make this easier, but I'm having a hard time figuring out how to get the VB help and Excel Object … |
| | Hi so i'm working on a project in c#. I have hundreds of xml files and I need to extract 6 values from each of the xml files and somehow display them on an excel datasheet. Here is an example of the xml file: [code] <XAxisCalib> <Max>288.93</Max> <Min>-48.08</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> … |
| | I got an assignment to search in a certain excel worksheet which I'm using the Find & Replace dialog of excel all I want is to make a VB6 program that will going to load the excel data into VB6 flexgrid and search hundred of words in a one click …  |
| | Hey guys, Just as the title says, I want to implement using an excel spreadsheet as an argument for a python script. I already have the layout of the spreadsheet, but I want to be able to assign the variables in my python script from specific cells of the spreadsheet. …  |
| | Hi, I´ve got following code for a office 2010 like tabcontrol in .NET 4.0 [CODE]<ResourceDictionary xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"> <ControlTemplate x:Key="OfficeTabControl" TargetType="{x:Type TabControl}"> <ControlTemplate.Resources> <Style TargetType="{x:Type TabItem}"> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type TabItem}"> <Grid SnapsToDevicePixels="True"> <VisualStateManager.VisualStateGroups> <VisualStateGroup Name="CommonStates"> <VisualState Name="MouseOver"> <Storyboard> <DoubleAnimation Storyboard.TargetName="hoverShape" Storyboard.TargetProperty="Opacity" To="1" Duration="0:0:.1"/> </Storyboard> </VisualState> <VisualState Name="Normal"> <Storyboard> <DoubleAnimation … |
| | Hi All, I have a section of my site that allows users to upload and download files. For security issues, We use a com object to take the file as a binary stream and store it on our network off of the web server (under a different randomly generated file … |
| | Hello i have problem in my software, i want to read file excel and compare data. If i use file excel with small size it run succesfully, but if i use large file i have fault. Please some body help me |
| | Hi guys Can anyone help me with this one? I want to insert a loop in my code to read all the data in excel file here's a portion of my code. [CODE] private void btnUpdate_Click(object sender, EventArgs e) { string directory = "D:/myFile.xls"; if (File.Exists(directory)) { Excel._Application myPartFile = … |
 | hi, I have Citrix Reciever for iPad and when I try to run a Microsoft office application, it says that the server is currently unavailable. The app works fine for my iPod touch 4th generation. Any solutions?  |
| | Hello, I have to append 30 Excel 2007 files, each with 6700 columns, into one. The problem is that in these files the columns are not in the same order(the column names are the same in all the files). Im having Python27 with openpyxl, Win7, MS Office 2007, MS SQL … |
 | So I've set up a data connection to a table on my website and the data imports just fine, but it formats the cells wrong. Case in point: The text coming in is "May 7". First Excel auto-converts this to "5/7/2011". But then it doesn't even display that, it displays … |
| | Hi everyone, I have a code which converts a html page into excel file. The following code has been working well so far, but Im having a problem of converting the html page into excel file after I had changed the localhost to another server. It's not able to generate …  |
| | Hello All Experts Please tell. Can I use Microsoft Excel Sheet in c sharp as addition of Students Monthly fee And save it in SQL Server ?  |
| | Hello for all i want to collected data from pdf form inserted in excel spredsheet i try many methode and some program for (PDF to Excel) but not work i have acrobat x pro and my pdf form (text,number ,pictures). and get data for all it's possible if any body … |
| | Hi all I'm looking to do what as far as I know is a straight forward enough task in excel...............just can't think the best way of doing it!! I am taking registrations for a course and I have two columns (K&L) for paid and fee Column L is the fee … |
| | i have two dbf that should write in excel file,,ive already done writing on the first table my problem is how can i join the other table from the other but theyre not going to combine,,first table id in the upper part and the second table is in lower part,, |
| | I have a excel spreadsheet that contains the following information: part name, part number, calibration, rev. level and other information. I also have a form that I have to fill out every month using the information from the above mentioned spreadsheet. Is there a way to input the spreadsheet information … |
The End.