629 Topics
 | |
 | 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! :)  |
| | 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 … |
 | 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 … |
| | 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 … |
 | 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 … |
 | 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 … |
| | Hi All, M trying to design a web portal which shows all my trackers and allows me to open it . the trackers are in ms Excel format. Please suggest me d best possible way to achieve the goal. Thanks Mukul  |
| | Hi, SIR I HAVE A SHEET IN WHICH I HAVE 6 COLUMNS FOR RICE INVENTORY. 1)Report No 2)IN/OUT/PROCESS/Fg(This column show whether Rice In, out,Proceeds & Finshed goods) 3)Product Name 4) In (If In & FG i have make entry of quantity in this column) 5) Out (If out or process …  |
| | I was wondering if anyone can tell me what is wrong with this code in EXCEL. I'm trying to fill in one cell (in this case, K2), based on the wording in an adjacent cell (in this case, J2). If J2 does not state "PENDING", then I want to reference … |
 | Greetings community Excel Errors: Unreadable content error in excel 2010. I have gone to many web sites in the past month or two and not able to solve this error. I dont have a pivot table. I hope somebody will direct me to right solution. Thanks |
| | Machine running Windows 7 Pro 64 bit. MS Office 2010. Problem is once there is a spreadsheet open and minimized and you click on a second spreadsheet shortcut, it won't open. You will get the blue circle so it is trying. You can do it through file/resent files and open … |
| | I am creating a software for my company in C#. The working process is like this. 1: we write information in an Excel file. 2: Then we go to the website (Company's customer support page) there is only one search box. and we search after appropriate information. it gives us …  |
| | I'm currently pulling out information from column B in an Excel worksheet + the worksheet name. How would I go about pulling information from column J (which has the same start row/end row as the information pulled out from column B) in the same worksheet and assigning it to the … |
| | hi i have a code here that export my listview items to excel but i want to customize each cell size and i want to format the date and landscape environment Try Dim objExcel As New Excel.Application Dim bkWorkBook As Workbook Dim shWorkSheet As Worksheet Dim i As Integer Dim … |
| | What's the simplest way to read an excel file, get cell 'A1' in table(1,2,3), B3 to table(1,2,3), B6 to Table... import specific cell to table.  |
The End.