629 Topics
 | |
| | Hi All, I am using cognos report sudio 8.4. I have got a problem in adding each cell to its next cell data (means running total not addition two cells). I tried with available report studio functions like running_total, Moving_total. I got errors. I am automating excel reports into cognos … |
 | I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group … |
| | helo friends. i need to deal with more than 10 excel sheets.. so i want to make an desktop application in Visual Studio(c#), which performs as followings..: 1) first user can choose on which file he wants to work on. 2) then retrieving column wise data, and performing many mathematical … |
| | Hello, The code below works almost perfectly except for two flaws: 1. It provides the full name of the file (workbook.xls) instead of just "workbook" 2. If there is more than 1 worksheet then the loop appends the previous worksheet to the filename. For example, Workbook1 has 1 worksheet Workbook2 … |
| | I want to import/upload excel files to sql server via cake php, it will occur Undefined variable: ext and Undefined index: the code are shown as below. Is there any mistake in my code? Thanks in advance! <?php App::import('Vendor', 'php-excel-reader/excel_reader2'); class UploadsController extends RealTimeAnalysisAppController { public function upload() { $destination …  |
| | i'm not sure what is the syntax error. I try in this source code in dreamweaver, it shows line 8 is a syntax error. $destination = realpath(‘../../app/webroot/uploads/excel/’); App::import(‘Vendor’, ‘php-excel-reader/excel_reader2’); //import statement class UploadsController extends RealTimeAnalysisAppController public function upload() { $destination = realpath(‘../../app/webroot/uploads/excel/’); //Set your upload path here if(isset($_FILES['Upload']['XLS_File'])); $ext = … |
| | Good Morning Everyone, May i know how to extract all data from a excel file and copy the data all over to another excel file? Example from Excel A, we have data EmployeeID Name Department 1111 John MIS I want to copy the data over to Excel B... may i …  |
| | Hi, I have a 3-column data (below) from excel file. How can I write a perl code to sort all rows according to the first numeric number of a numeric interval and the word "complement" if they appear before the numeric interval as shown in the expeceted output below? Data: …  |
| | Hi All, How can I export data from gridview to excel sheet in ASP.net? |
 | Was updating tags, at some point I got to this: http://www.daniweb.com/tags/tables Is this a caching issue? It's showing "usability" and "excel". I do come across tags in the tagclouds, where the link goes to the "Oops" page (e.g. http://www.daniweb.com/tags/three). Am guessing it's because I removed that tag, but the cached …  |
| | Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … |
| | Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn … |
 | hello thank you for your good solution but your solution always assume external workbook to be open, how to work with current opened workbook? Dim oxcel As Excel.Application Dim owb As Excel.Workbook Dim osht As Excel.Worksheet oxcel= New Excel.Application oxcel.Visible = True owb= oxcel.Workbooks.Open(Path) osht= owb.Worksheets(1) now I developing add-in … |
 | When using my Toshiba laptop the screen went black for a few seconds, came back, the went black again permanently. I turned it off but when I turn it back on the Toshiba loud up screen comes on but the screen again goes black afterwards. The solution of, 'turn it … |
| | Hi I am trying to upload excel file data thorugh .net uploading code. But i am getting an error message. can any one please help me to resolve this. **Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_residentupload.aspx.cs" Inherits="add_residentupload" %> <table class="table-list"> <tr> <td width="30%">Upload File</td> <td><asp:FileUpload ID="fupUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" …  |
| | i need to the step by steps screenshot and coding |
 | can any one help me.. how to export a table echoed in php to an excel through a button ?? |
| | 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 … |
| | 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 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 … |
The End.