Hello ,
Is there no answer for this question? Or please let me know if the question is unclear.
Regards,
Shara....
shara
Last Activity: Feb 13 '08, 12:13 PM
Joined: Dec 4 '06
Location:
-
Is it possible to add a button programatically in excel worksheet using php
Hello,
Is it possible to add a button in excel sheet using PHP ?Or can i add it using HTML within a script tag using java script or anything?
If so, Please help me with the code to insert the button and how to handle the click event?
Thanks&Regards,
Shara. -
Hello Jenkins,
I tried searching for excel API call and got a code like this:
...Code:<?php // set up excel $excel = new COM(”excel.application”) or die(”Unable to instantiate excel”); // run Excel silently, since we don’t want dialog boxes popping up in the background $excel->DisplayAlerts = false; // open up Excel file and select the first sheet, which contains the inputs
Leave a comment:
-
Hello Jenkins,
This is a dynamic report that affects a substantial amount of users.I'll try the proposed.
Thanks for your help.
Regards,
Shara....Leave a comment:
-
Hello,
Please consider the query, as its important for me to solve it.
I've been trying to search for a solution through out the day, but its of no use.
Any help to solve the problem in some other way is also welcome.
Thanks&Regards,
Shara....Leave a comment:
-
Php code to run a macro after outputting excel sheet
Hello,
I have a php script that outputs an excel sheet.The user has to download macro every time he wants to run the macro on the excel sheet.
Is there anything in php where the code downloads macro also along with the excel sheet or something like a button in excel sheet itself, clicking on which the macro runs on the excel sheet.
Any help is well appreciated.
Thanks&Regards,
... -
directing the output of exec function
Hello there,
I am using a code in which i send a variable to a webpage and want to redirect the output to an array.I am using the following code:
[code=php]
exec("http:page address?id =".$rmt_string, $rmt_array);
[/code]
Now if iam trying to access the variable "$rmt_array " there's nothing inside the array from which i assume that the above command is not executed.Can... -
Showing the progress of an upload processing script in real time.
Hello there,
Right now, iam having a php script that uploads data to a server and finally gives a message to the user that "upload is successful".But i want to change it in such a way that the user should see some process going on like the following sequence of steps:
records being transferred to the server.........
updation being done...
and then finally it should give
upload is successful..... ..... -
Passing multiple values of a select box to another php page
Hello there,
I want to pass multiple values selected in a select box(HTML) to another php page.I tried doing in several ways but of no use.Can anybody please help me with this.
The code i used is in page 1 is:
[CODE=html]
<td align="left">
<select multiple name='srtestrun[]' style='width:30 0px;' size='10' >
<?php
if($srproject !=...Last edited by pbmods; Jun 1 '07, 04:31 PM. Reason: Changed code language. Thanks for using CODE tags! -
Please help me on..passing a variable from a file using unix to a php file..
Hello there,
I have to pass a variable from unix as an input to a php file.
The syntax i used is
Now report_errors is not being executed and the php start symbols "<?" etc all are being thrown as syntax errors.I dont have any idea why this is happening with php scripts on UNIX platform.Can anybody please help me with this...Code:var1="SUCCESS" report_errors.php var1
-
Error in the commented code
Hello there,
Can anybody please help me with this.I've a php code in which i've commneted certain part of the code .But still i'm getting a message that there is an error in that commented part.I tried removing the commented part completely but still getting an error message that there is an error at the line after the last line of the code.Can you please suggest me what could be the possible reason for this.
... -
Hello Vijay,
Thanks for responding.But i dont have a hint of idea about what you told like flex grid.Can you kindly give me the approach with VB macros?
Thanks,
Shara....Leave a comment:
-
using arithmetic operations to fill in data in the cells of an entire column
Hello there,
I am working on macros and now i am calculating the value of columns cell by cell based on the previous cells of the corresponding row in that column.Do i have any method where i can attribute a formula to a column like
data in AE=data in AB+data in AC-data in AD ....
so that for every row cell in AE column the corresponding row cells of the other columns are used to calculate the value.
... -
converting numbers to column alphabets
Hello there,
Can anybody help me with this.I'm working on VB macros and i came across a situation where i have to convert numbers to column alphabets i.e. 1=A,2=B,....... 27=AA,28=AB.... .....53=BA,54=B B.........so on till 256 column numbers.I'm new to VB macros and have no idea of how to achieve this.Please can you provide me the guidelines?
Thanks in advance,
Shara. -
redirecting xls output to a directory
Hello there,
I want to redirect the output of one phpscript that generates an xls file as an output to a directory.I'm using the following code
[php]
shell_exec("/project_report/full_report_exp orting.php?test _runid=".$test_ runids[$i][0]." -nolog > /project_report/xls_files/".$project_name ."-".$test_run_nam es[$i][0]."-".$date."-Full_Report.xls ");
[/php]
... -
Hello Ronald,
full_report_exp orting.php is working well coz the else part of the below given code is showing the output perfect.
<?php
ob_start();
session_registe r("SESSION");
require_once("W orksheet.php");
require_once("W orkbook.php");
require("../include/smcconf.php");
require("../include/smclib.php");...Leave a comment:
-
Hello Satya,
That additional space is not there in actual script.It is given here by mistake.
My problem is that full_report_exp orting.php generates an xls file taking test_runid as input.Now i want to direct the generated xls file into a directory as a file,say some_file_name. xls.
I also used
shell_exec("/www/ngnsite/D/FSD_ENS_RnD_TTS/project_report/full_report_exp orting.php?test _runid=".$test_ runids[$i][0]."...Leave a comment:
-
Writing the output of a function to another file
Hello there,
I used 'header' function to call a php page.The output of this page should be sent to a different directory as a file in the directory.
My code is like this
header('locatio n:full_report_e xporting.php?te st_runid='.$tes t_runids[$i][0]);
Now full_report_exp orting.php generates a xls file which i have to store in a directory(name-xls files).
I'm quite new to php and dont... -
Thanks for responding.But its not that i want to pass a varible over forms.If i am retrieving the value of a variable directly from one page to other to perform some action,i am able to get some value for $$var.But its not the case if i want give a warning (button submit)before taking that action and then using $$var after button submission.In this case i'm not able to have any value for $$var.Can you please help me with this....Leave a comment:
-
somebody help me!passing variable to same page after button submit
Hello there,
Can anybody please help me with this.I used one php page from where i've sent a variable to other php page thru a hidden field (HTML).In that page i'm able to retrieve the value before i submit a button.From that page i forwarded the same value to the same page after submitting the button.There i'm just able to use the value as a static content.if fc is the value i retrieved
for ($i=0;$i<$fc;$i ++)...
No activity results to display
Leave a comment: