Search Results

Search found 856 results on 35 pages for 'spreadsheet'.

Page 8/35 | < Previous Page | 4 5 6 7 8 9 10 11 12 13 14 15  | Next Page >

• How can I detect if a range of cells contains only identical values or not in Excel?

  - by Sorin Sbarnea

  I have a range of cells and I want a formula that says if all these contains the same values or not. Usually for two cells I would use if but I want a solution that would work for ranges. I don't want to have 20 IFs one under another.

  Read the article

• Excel - Dynamic row reference based on the row I paste a formula into?

  - by michaelmichael

  I have a simple, oft-used formula that I paste as plain text into spreadsheets I receive. It looks something like this: =IF(D8="FOO", "BAR", "BAZ") It looks in D8 for the word "FOO". If it finds it it will show "BAR". If it doesn't it will show "BAZ" It works great. The problem is I have to paste this formula as plain text into many…

  Read the article

• List of objects to Excel Spreadsheet?

  - by Max Fraser

  Anyone know of some code out there that does this already? I have a bunch of pages with data grids on them in an admin website they want to export them to Excel, was hoping someone had this written already - or if not I'll post mine when I am done.

  Read the article

• Create shortcut key to insert new row using Excel 2010

  - by Dave Jarvis

  Tried to create a macro in Excel to insert a row: Sub InsertRow() ' ' InsertRow Macro ' ' Keyboard Shortcut: Ctrl+Shift+I ' Selection.EntireRow.Insert End Sub However, this does not insert a new row without first manually selecting a row. Every solution I've found requires that a row be highlighted before inserting a new row. …

  Read the article

• Please suggest ways to manipulate Excel spreadsheet without using Excel object as web server does no

  - by Hari

  I would like to know the options to manipulate the Excel spreadsheets using ASP.NET 2.0 without using Excel object as web server does not have MS Office installed.

  Read the article

• Php code to convert .xml to .xls(Basically from xmlExcel to Excel spreadsheet)

  - by developer

  Is there a way to convert .xml file to .xls using php code?

  Read the article

• Getting value in ZK by passing from java

  - by Thida

  I could not take the value that I pass from JAVA code in ZK Spreadsheet (http://www.zkoss.org) file. Here are what I am doing: In java side I call the .zul file String filenames = "test.txt"; htmlPane.setContentsURL("preview.zul?filename=" + filename); In preview.zul file < zk < zscript < ![CDATA[…

  Read the article

• Google Apps Script: how to make suggest box library to work?

  - by Pythonista's Apprentice

  I'm trying to add an autocomplete feature in my Google Spreadsheet using this Google Apps Script suggest box library from Romain Vialard and James Ferreira's book: function doGet() { // Get a list of all my Contacts var contacts = ContactsApp.getContacts(); var list = []; for(var i = 0; i <…

  Read the article

• Import Excel into Rails app

  - by Jack

  Hi, I am creating a small rails app for personal use and would like to be able to upload excel files to later be validated and added to the database. I had this working previously with csv files, but this has since become impractical. Does anyone know of a tutorial for using the roo or spreadsheet…

  Read the article

• How can I remove rows with unique values? As in only keeping rows with duplicate values?

  - by user1456405

  Here's the conundrum, I'm a complete and utter noob when it comes to programming. I understand the basics, but am still learning javascript. I have a spreadsheet of surveys, in which I need to see how particular users have varied over time. As such, I need to disregard all rows with unique values…

  Read the article

• how to implement OOP using QT

  - by kaycee

  hi, this is a simple OOP QT question. my app consists of main window (QMainWindow) and a table (QTableWidget). in the main window i have arguments and variables which i would like to pass to the table class, and to access methods in main widnow class from the table class, how should i do it ? …

  Read the article

• Creating Excel or Excel compatible Spreadsheets on the server side in C#

  - by CVertex

  I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have…

  Read the article

• Accessing Google Spreadsheets with C# using Google Data API fails with Mono

  - by Maurits Rijk

  I'm trying to access my Google spreadsheets using the GData API. I have followed the example which looks like: var service = new SpreadsheetsService("myTest"); service.setUserCredentials(username, password); var query = new SpreadsheetQuery(); var feed = service.Query(query); This…

  Read the article

• PHPExcel feature question

  - by AlexV

  I want to know if PHPExcel can: Create Excel spreadsheets with embeded image. The image must be compressed (jpeg, png, gif...). Create Excel spreadsheets for different Excel versions (2000, 2003, 2007...). I'm pretty sure it can do this but I can't find it in the official docs. …

  Read the article

• Inserting scientific data into open office Calc

  - by finemann

  hello, i have some scientific data that i want to insert into oo.org calc. when i do this, instead of displaying 0.35678 in a cell it displays 0.35 (only the first 2 digits after the decimal). but on clicking the cell, the formula bar shows the correct value...please help

  Read the article

• How can I query Google Spreadsheets API with a string value?

  - by ColinM

  I am using Zend_Gdata_SpreadsheetsListQuery. In PHP my query is: "confirmation=$confirmation" The problem is that $confirmation = 'AB-CD-EFG-012345'; Apparently the hyphens are causing problems with the query and the exception thrown is: Uncaught exception…

  Read the article

• Reading Excel Files In C# Always Results In System.__ComObject?

  - by Soo

  This is the code I'm using to read an xls file: Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(filePath, 0, true, 5, "", "",…

  Read the article

• (Pivot) tables generation

  - by Yasir Arsanukaev

  Hello. We use Excel VBA to load data using SQL, process it and generate (pivot) tables. I wonder if there any other decent alternatives. I've been thinking on PDF generation but not sure if there are handy tools to construct pivot tables. Important requirement…

  Read the article

• Problem with skipping empty cells while importing data from .xlsx file in asp.net c# application

  - by Eedoh

  Hi to all. I have a problem with reading .xlsx files in asp.net mvc2.0 application, using c#. Problem occurs when reading empty cell from .xlsx file. My code simply skips this cell and reads the next one. For example, if the contents of .xlsx file are: …

  Read the article

• Can Google Forms do carriage returns/ line feed

  - by Simon

  I am trying to write a pre-qualification programming exam, hopefully using Google Forms... however they seem to be unable to do new-lines in both the questions and the section headers... My current format is new page for each question, with a "section…

  Read the article

• excelsheet query

  - by Goodwill

  Hi, dadasdf\sdasdasd\qazxbbjj\test.txt Above is the string in cell A1 in excelsheet,I want to extract the last word from that cell.i.e,I want only test.txt,How can I acchive that using excel function.If it is acchived by declaring any variable then…

  Read the article

• Any function / method in Java to implement a "freeze panes"-like sheet?

  - by MikeG

  We are using Java and Javascript to try to display a huge sheet with freeze panes, but it is being very difficult. Does someone know about a library, method, script or something, either free or commercial, to do this? Thanks.

  Read the article

• How can I convert Excel VBA to Google spreadsheets Javascript API?

  - by Bearjcc

  I have recorded a macro in Excel, but I want to run this code in Google spreadsheets. I do not know how to program in either code. How do I convert them? I tried an online VB to Javascript converter, but this does not work with VBA.

  Read the article

• Google sheet dynamic WHERE clause for query() statement

  - by jason_cant_code

  I have a data table like so: a 1 a 2 b 3 b 4 c 5 c 6 c 7 I want to pull items out of this table by dynamically telling it what letters to pull. My current formula is: =query(A1:B7,"select * where A ='" & D1 & "'"). D1 being the cell I wish…

  Read the article

• How to lookup an IP address in an Excel spreadsheet?

  - by Kevin Williams

  I am working with a decent sized spreadsheet of domains and server names. Another user of the spreadsheet needs the IP address for each of the DNS entries on the worksheet. Instead of manually adding and then having to maintain this list I was…

  Read the article

< Previous Page | 4 5 6 7 8 9 10 11 12 13 14 15  | Next Page >