4,334 Topics
 | |
| | Hi there, Thank you for accepting me within your community My name is Bernard, I'm a French-speaking Belgian citizen living and working in Thailand since December 2003. I'm not an IT expert. I've been using VBA since Excel supports it (Excel 5-1995?). I work here as a school administrator and …  |
| | Hi Guys, I'm new to awk and trying to format an stadout "temp.txt" to csv format so I can export to excel. I'm having issues here is my code so far..If any one can help to see the light!!! The ### sign is the second server on the list each … |
| | I am importing data from an excel worksheet in to a sql table, one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data for example the number "5900397732209" is … |
| | I've been coding since 1966 and have seen a number of languages come and go and also held up as "THE" language. When Microsoft came out with Visual Basic 3/4/5/6 (Classic NOT Net), and with VBA as part of their office suite, I jumped on it and never looked back …  |
| | guys - most of the export to excel code i've found really doesn't wind up being excel. it's simply HTML w/ a .xls tag on it. and i've done this for years in asp.net, winforms in both c# & vb.net. but it's always a hack. can someone point me in … |
| | Hi! Its been a while since i've been here but this place was always good to me before. Well my computer was really slow and 100% usage, i also noticed mysearchdial popup through firefox and i thought it was like an addon so i actually used that it silly me … |
| | Hi I have a Help.doc file in my application. How can I open this file on a winform to page 2 (say)? How can I open it to page 2 using a WebBrowser control? 'Microsoft.Office.Interop.Word added Private Sub OpenMyWordDoc() Dim MyWordApp As Word.Application Dim MyDoc As Word.Document MyWordApp = CreateObject("Word.Application") … |
| | Hi this is Sukhdev, I am new in php and wish to know how to import the data from excel sheet to mysql Table; 1. I have a table with the name of city in mysql with following fields; city_id,city_name,tier_id,tier_name,state_id,state_name 2. what would be the function for uploading above fields, …  |
| | Guys I need your help again I use this code to copy values from excel spreadsheet to datagrid. Try 's = Clipboard.GetText() Dim tArr() As String Dim arT() As String Dim i, ii As Integer Dim c, cc, r As Integer tArr = Clipboard.GetText().Split(Environment.NewLine) r = Form1.DataGridView1.SelectedCells(0).RowIndex c = Form1.DataGridView1.SelectedCells(0).ColumnIndex … |
 | Group, I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I hope someone can help. I'd like to use VB (if possible) to copy from a specific range in Spreadsheet1.Sheet1 (let's … |
 | I import a spreadsheet (csv) into my sqli database (keeps a track of all our firewalls) there are 10 excel columns , one for each connected network on the firewall. i would like all these columns to be imported as one entry in the database, so 1 database field would … |
| | i want the whole excel file has to open in web page n moreover have to enter some input and will hv to **insert/update** based on formulae cells. Is thr any chance to achieve this?  |
| | Dear all, I have exists excel file on server. Now, I want output the file by php. I have this code: $file = "test.xls"; $file=basename($file); if (file_exists($file)) { header('Content-Type: application/ms-excel'); header('Content-Disposition: attachment; filename='.$file); ob_clean(); flush(); readfile($file); exit; } When I click download button, I can open file, but appear "missing … |
| | I am trying to do a Page to PHPExcel to user fill an Html Page and send to PHP and it will: Open my default Excel Page and after fills the Excel Page with information send by Html What i dont know is how to do it read if is … |
| | I have a button which make it add data to accees database,but i want to another button which will make export data from access to excel. here is my button : try { string cmdText = "Insert INTO data(Name,Mail) Values(?,?)"; db_conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Alpozkanm\\Documents\\Visual Studio 2012\\WebSites\\IntegratedSubscribeSystem\\veri.accdb;Persist Security Info=False;"); OleDbCommand …  |
| | <?php include ('pages/dbconnect.php'); $rekdep=mysql_query("SELECT * FROM t_org ORDER BY dept, com ASC"); echo "<table class='gridtable'>"; echo "<tr><tr><th> Departement</th><th> Commune </th><th> ORG </th><th>Animal</th>"; echo "</tr>"; echo "</tr>"; $odl_dept = null; $odl_com = null; $odl_org = null; while($dep=mysql_fetch_assoc($rekdep)){ //List of department if($dep['dept']!=$odl_dept){ echo "<td>".$dep['dept']."</td>"; } //display blank td if the same department … |
 | good evening people,i'm creating an application where i'd like to import and save a list of people in an excel sheet to my database in mysql, using php, And i'd like to modify it through a form using php! Can anyone have an idea or something which will help me … |
| | More and more guys are using the TAB for its features like email, phone,camera, small office like PP word excel. How is it really different from a cell phone? Is it going to replace the LAPTOP?  |
| | I have a column in a spreadsheet labled SEX with the value of 1 or 2 for male or female. How do I calculate the average number of males and females? Or should I use a different value to calculate?? |
 | Can i help U ? Need to get information into the Order .  |
 | Hi.. I really don't know what to do with my Program, it is needed to have a excel file on MDI Form, But i really don't how to. Can somebody help! Highly Appreciated. : ) Thanks! :)  |
 | So here I am working on a Sunday morning, as usual, and I when I fire up my laptop (which serves as my desktop) a message appears informing that an update is being applied and it won't take long. Imagine my surprise when it turns out that this update appeared … |
| | I'm using: Windows 7 Word 2010 Visual Studio 2013 Express for Desktop An Access database with one table As this project is for proof of concept I'm keeping things very simple until I can get the VB working correctly. The project consists of one form (Audit.vb) which contains one textbox … |
| | Like what we see in the Microsoft office word, if i wrote "This is abble" will show me a red line under the word. my project is load text file in the Richtextbox and correcting the wrong words, every thing is fine except this thing. so any information or details … |
| | pls help me i need this code to view my excel data in vb6 forms only.  |
| | If your Excel spreadsheet is laid out as regular columns and rows with a header row that identifies the columns then this code will allow you to read the data using ADODB the same way you would read records from a database table. To try this code 1. Create a … |
 | I really didn't know where to post something like this so sorry guys if this not the right section I have a text file looks like this   I want to import it into Excel file so each info will be in seperated coloumn , even the … |
| | hi i am creating a program that needed an excel app., and i already do it, at first no error, but after a sudden, an error appeal, here is a error. **Microsoft.Office.Interop.Excel.Application' is not defined.** i am still new and still exploring in vb.net. thank you in advance! Any help … |
 | Hello I am using jxls quite fine. I'm sort of on my last lap with exporting my data to a file. However all I want to know is, how do I display my collection in the same row please? I've manage to do this downwards in the same column, but … |
| | i like openoffice much better than ms office, what do you think? After having to use ms word 2007 and other products under the ms office package and vista OS, i started to like non-microsoft products. Thanks to these crap(i dont remember it can be crab), i even started to … |
| | Hi. I have a c# project created in Visual Studio 2010. The project runs successfully on Windows XP 32bit but I get an error when building on Windows 7 64bit. The error is as follows: Could not load referenced assembly "C:\WINDOWS\system32\stdole.dll". Caught a FileNotFoundException saying "Could not load file or … |
| | hi! i am creating a program that need to import excel file. i really don't know how to. Can someone help? Thanks in Advance! God Bless! |
| | Hi there, I am using Libre Office Calc in my windows 8 PC. I need to maintain a calc sheet for tracking my home electricity meter reading. pLEASE LOOK THE IMAGE. FUNCTION OF CELL A2 = if c2 = "" then value = "" otherwise value = TODAY(). This will … |
 | when i want to reinstall windows to my computer it doesnt happen and it says dat "a problem has occured while reseting ur pc and when i wanted to install microsoft office 2013 on my pc it says dat "deas not enough space in da hard drive" |
 | Hello; I got some kind of infection or something last week, which caused my virus software not to update, and finally my computer to totally crash and would not reboot. I successfully recovered my system from an image (it was one level up of messy from actual system restore - … |
| | what i am trying to do is make a program to read an excel file that i already have , choose certin columns depending on its header title then paste these columns into sheet2 . the problem is when i check for the columns i want to extract it gives …  |
 | I have an Excel spreadsheet that contains names. addresses and various other information. I have word wrap set for all cells in case some new data gets entered that's long. If I sort the data, the data that was in the cells that were word wrapped will end up in … |
| | Hi, I have a VBA script that places WinForm dropdown boxes (xlDropDown) into an excel workbook dynamically. For some reason, on the 17th box (called "INCL" & i + 1 in the code below), the data type of the placed shape becomes msoAutoShape instead of msoFormControl. All of the following … |
 | # i get the excel values, but i dont separate the column value, how to i get the columns value. # include 'simplexlsx.class.php'; $xlsx = new SimpleXLSX('bb.xlsx'); list($num_cols, $num_rows) = $xlsx->dimension(2); foreach ($xlsx->rows(2) as $key => $r) { echo $key . "<br>" . $r; } |
| | How can i copy data from a named range in a different worksheet and paste it to another worksheet all done without activating both sheet. With all code just behind a form button If i try to use the statement **application.goto reference:="x"** where x is the named range but this … |
| | Hi, I need to create a page where an admin can upload an excel worksheet in the .xlsx file format, this is then read and writen onto another php page. I'm new to PHP so I am confused by the code, I can find help on .xls but not accepting …  |
 | This may require an expert in MS Excel, I happen to have version 2007. The issue involves how Excel is distorting images when placed in a sheet. Imagine this scenario, and maybe duplicate it on your end: 1) I use the graphic borders feature of MS Word to create a … |
| | Is it possible to implement theme of Microsoft Office in my windows application. I mean when anyone changes theme of Microsoft Office it should also make change the theme of my windows application. If its possible, let me know how to do that?  |
 | Sheet1 A1: Football A2: Rugby A3: Basketball Sheet2: A1: A2 A2: B4 How can I get a location of a field from String? Is it even possible? *eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'* |
| | Hi Experts my excel data is copied successfully to the listview. But on importing to database, I get this error. InvalidArgument=Value of '5' is not valid for 'index' ParameterName:Index ================= I have 2 problems ================= Problem 1: What should be the problem when I importing from listview(I think it is … |
| | I just finished upgrading Windows 7 Pro to Windows 8.1 Pro. I thought it was supposed to keep all files and applications, but only a few of the applications were carried over. Seems like I have to re-install most of the programs, especiall games, Office 365, and Microsoft Visual Studio. … |
| | My task bar in XP changed color to a pale green and the font size changed (I am paritally color blind, so color is a guess to a degree) from the normal blue. When that happens, the wireless internet won't work either. I have run all the programs that you … |
| | Hi, can anyone help me. I've trying to display existing word document in vb.net but i keep getting this error: D:\System-new\DLIMS\PSM2\FormUserGuideWord.vb(58): Type 'COMExceptionMessageBox.Show' is not defined. I have add reference (Microsoft word 11.0 because im using ms word 2003) to my project but i still cannot display the word document. … |
 | Sorry in advance if this is the wrong place for this, it's the closest I could find. I need to create a macro for an Excel 2010 spreadsheet so that the active cell will cycle through three choices: "Y", "N" or "" - the last being simply an empty string … |
| | Well, I installed Microsoft Office, but whenever I try to run the computer in normal mode, it freezes. So, I have to try and uninstall it in safe mode but it says you can't. So, I need help. |
The End.