473,406 Members | 2,293 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Insert an equation in a CSV cell

code green
1,726 Expert 1GB
Is it possible to write a literal equation to a csv file.
Something like =D2/E2*100 so that Excel calculates and displays the result?
Feb 11 '08 #1
3 1708
code green
1,726 Expert 1GB
Yes of course you can
[PHP]$equation = '=D'.$row.'/E'.$row.'*100';[/PHP] or variations thereof.
Thanks for looking.
Feb 11 '08 #2
Markus
6,050 Expert 4TB
Yes of course you can
[PHP]$equation = '=D'.$row.'/E'.$row.'*100';[/PHP] or variations thereof.
Thanks for looking.
You're welcome.
Post back anytime you require my assistance again!
Feb 11 '08 #3
code green
1,726 Expert 1GB
Ok, what about this one, inserting a function in a CSV cell
[PHP]$equation = '=ROUND(('.chr($column+$key).$row.'-D'.$row.')/'.
chr($column+$key).$row.'*100'.",".'1)'[/PHP] The comma in the Excel ROUND function is stripped out.
I would not have been suprised to see the '1' pushed to the adjacent cell,
but it simply disapears.
So I end up with
Expand|Select|Wrap|Line Numbers
  1. =ROUND((G2-D2)/G2*1001)
Any idea how to keep the comma there?
Feb 11 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: John A. | last post by:
Hello all! I've got a big bunch of pages using tables for layout. Eventually I'll get them set up with more modernized code, but in the meantime I'd like to slip in a little quick holiday...
1
by: Abareblue | last post by:
I have no clue on how to insert a record into access. here is the whole thing using System; using System.Drawing; using System.Collections; using System.ComponentModel;
2
by: Tolga | last post by:
How do insert a user control i have created into a datagrid cell. Basically i am trying to create a column of my user controls. This is what i have tried so far. int i = 0; while (i <...
3
by: Neil Zanella | last post by:
Hello, I am trying to execute ADO.NET INSERT statement where one of the fields is coming from a password HTML control. When I access the text with password.Value and print with Response.Write...
0
by: None | last post by:
Hi, I'm using DataGridView in my Windows Forms project. I need to know how we can insert an image into the specified cell . I tried with the following code.
0
by: Daniel Setterwall | last post by:
Hi, I would like to create a macro/application in Excel where a set of data is transfered to a chart, and the trendline equation is calculated with a given number in a cell. I know how to create...
6
by: Trev17 | last post by:
Hello, I am new to C++ and i have tried for several hours to make a program my teacher has given me as a lab. Here is the Lab question: the roots of the quadratic equation ax^2 + bx + c = 0, a...
1
by: nandan | last post by:
Hi, Iam using devexpress xtrareports with vb.net .I want to insert page break after writting some contents to the Detail area(band). can anybody help me?Thanks in advance Nandan I using the...
2
by: Olumide | last post by:
Hello, I've got this nice inner class that I'm holds a set of "FrontPoint" objects as shown below. Unfortunately, the find and insert methods trigger massive C2784 errors. Would someone please...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.