excel

Change all the string values in Excel column?

I have a column. THe column is the number 2 all the way down. What is the fastest way to make all the cells in this column a 3? The values are of string datatype I believe. ...

Checking an external list for duplicates in MySQL table?

I have a MySQL table and an Excel file. I would like to update the MySQL table to include the information from the Excel file, which is simple -- just write a quick formula for each line that creates the appropriate SQL statement. But first I'd like to check that all of the data matches properly. So if a given line has WidgetID 1001, ...

Grails: How do I export a grails list to Microsoft Excel?

I have a list with information and I want to export it to Excel. How do I do it? Is the "Export Plugin" any good? I think I saw one a while ago to export files to Excel but I can't find it anymore. ...

Check two codes and display an other between two lists

dHi, I have some work in Excel but I can't manage to work out how to do it. I have two sheets that contain: Sheet 1. CodeA and CodeD Sheet 2. CodeB and CodeD what I have to do is to find out the matching CodeA with CodeB. I've tried Vlookup but it won't work and i don't now why. I've tried with Tags, both in the same sheet but it stil...

creating excel macro for adding rows

hello, i am new to VBA and i want to create a macro in excel that add a row when i reach a certain cell. any help appreciated ...

VBA global variables, multiple workbooks

I have a VB application, that uses some global variables to store data that is required by multiple forms and modules, this works fine. However if a user opens up another workbook, running the same VBA application, then they end up accessing (and changing) the same public variables. How can I have workbook level global variables, or if ...

Excel Macro: is it possible to find Row heights and Column widths of a worksheet?

Is there any way of finding the height of the ROWS from 1 to 50, and the width of the COLUMNS from A to Z in an Excel sheet without manually clicking and writing down the answer? Thanks Michael. ...

C#: Datagrid to Excel .Cell border is missing in the created excel file

I am trying to create an excel file from datagrid in my asp.net page using the below code.I am able to create the excel file.But the created excel file does not has the cell borders.Without the cell borders,it looks like a word document. My code is Response.Clear(); Response.Buffer = true; Response.ContentType...

Import Excel to datatable

Hello, I am using syncfusion to import excel to datattable.when the datat is imported to datatable the columns are all strings .how to convert these columns to specific datatype?how do i validate the column data type? using Syncfusion.XlsIO; private void btnImport_Click(object sender, EventArgs e) { ImportExcelFile...

read write excel file on server

I would like to know your libraries recommendations to read and write Excel applications on ASP .NET website. I have tried GemBox and NPOI, because they don't required Excel to be installed on the server, but they have some limitations on handling Excel files that are marked to read only. Any good and stable libraries that you recomend...

Copy rows in excel to sheets if condition is . .

Hello First up I’m a novice when it comes to this and have been trying to find and adapt scripts unsuccessfully, hope someone can help. I'm trying to copy entire rows of the Sheet ‘All’ to another sheet according to the data in column D There are multiple values in column D (Homework/Advanced/Beginner) and the sheets these rows need to ...

how to read password protected excel in python

I'm new to python programming, and I am trying to read a password protected file using python, the code is shown below: import sys import win32com.client xlApp = win32com.client.Dispatch("Excel.Application") print "Excel library version:", xlApp.Version filename,password = 'C:\myfiles\foo.xls', 'qwerty12' xlwb = xlApp.Workbooks.Open(fi...

detect EOF of excel file in Python

I have written a code for detecting the EOF of an excel file using python: row_no = 1 while True: x = xlws.Cells(row_no,1).value if type(x) is None: break else: print(len(x)) print(x) row_no = row_no + 1 i expect the while loop will stop then x becomes a "blank cell", which I support to be None,...

Excel import to database using C#

Hi please find the screenshot attached and provide me the logic how we can acheive this. I need to import this excel file. This is a sample image. I have no. of header rows and no. of columns will differ in each header. Here is another information about the excel file. Col cells are set with background color. IS there any way to read t...

VB macro to open a SaveFileDialog using the Microsoft Project application

I'm working on a VB macro which generates an Excel report out of a Microsoft Project planning. In order to save the report, I have to open a Save File Dialog by calling GetSaveAsFilename("name", , , "Title") but I don't want to use the Excel.Application for this because I'm supposed to activate it first which doesn't make sense. How s...

VB(A) : looping to find previous sheet

Hi In Excel, i have sheets named after the working day. So, I don't have weekends nor special days (holidays and so). I've created a function : previous(x), with x the number of days worked. I want my function to give me the date (mm-dd format) of n-x day, n is the current sheet's day edit: sorry day1 and month1 because day and month ar...

How to trim text in a column with VBA - Excel

How can I trim a the text in each cell in a column? If the syntax is like: "[email protected] (name name)" and I want to delete "@twitter.com (name name)" from all cells in the column being left with only "blabla" in the cells. Any ideas? ...

What do I use to display CSV data as a chart?

I have a set of data stored in text files, which I have now via Perl put into a CSV file. The data in question now needs to be displayed in a chart. What suggestions do you have for doing this? XML was suggested, but XML can't put the data into a chart itself. Ideally what would happen is: the data would be decoded from the text file, ...

Exchanging variables between powerpoint and excel VBA

I have a powerpoint pres that grabs some data from an excel sheet when a button is pressed. Set EXL = New Excel.Application EXL.Visible = False Dim XLApp As Excel.Application Set XLApp = GetObject(, "Excel.Application") This is how I set the new excel application. What I'm wondering is how I can send over a variable from my powerpo...

Office clipboard takes time to show changes

I am facing a very weird problem in Excel. I have overridden the CTRL+C and CTRL+V keys and on copy, I put my custom DataObject on the clipboard that contains both the Excel formats and my custom formats. I copy my data to the clipboard and it gets copied without any problem. I can also see it in the Office Clipboard. Now I copy some te...