Excel

Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable.

Turn Your Excel Workbook Into A SQLite Database

Turn Your Excel Workbook Into a SQLite Database Transforming spreadsheets into queryable database tables

Python Excel: The Definitive Guide

Python Excel: The Definitive Guide. Learn how to read and import Excel files in Python, write data to these spreadsheets, and find the best packages to do this.

How to Handle Spreadsheets in Python using Openpyxl Package

Learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets, extract information from spreadsheets, create simple or more complex spreadsheets, including adding styles, charts, and so on.

How to Integrate Python and Excel with xlwings

How to integrate Python and Excel with xlwings

Microsoft Excel Tutorial 46 - Slicer and Timeline over Pivot Table in MS Excel

In this MS Excel tutorials video, we are going to see how to connect one slicer with more than one Pivot Table in MS Excel. Apart from this, we are also going to implement one more filtering criteria that is known as Timeline

How to Read an Excel File using HTML 5 and jQuery

This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.

Python vs Excel: Create a Linear Regression

In this article, we compare between creating a linear regression model in Python and Excel. The both tools can be used to create the linear regression model easily. The Excel is a quick and easy way to create the model, but cannot handle much large amount of data. On the other hand, Python works with large datasets easily.

How to Make a COVID-19 Rose Chart?

Learn how to Make a COVID-19 Rose Chart. A worldwide rose chart guide for you!! Rose chart is a very useful chart to show data that has many kinds of categories. Come to see how large data shows in a rose chart and how to make it!

How to Read and Analyze data from an Excel file in Node.js

In this post, we'll share for you How To Read An Excel File In Node.js

HTML 5 Tutorial: How to create a table using HTML tags and Stylesheet (CSS)

In this article, we want to show you how to create a table using HTML tags and Stylesheet (CSS). HTML table may vary depends on data and style requirements. Sometimes, in the real application, we use an HTML table as a layout of the Email template in HTML format.

Excel vs SQL: A Conceptual Comparison

An experienced Excel-user’s perspective of SQL and why it’s worth learning.

Accessing Google Spreadsheet Data using Python

If you’re building a simple internal app and you might probably be thinking that ‘I’m going to need a database now right!’. Well, Not so fast.

Strip all formatting from Excel file on load

I want to strip all formatting (borders etc) from an Excel file when it is loaded before it fills the data into a data table.

Using OR logic on an array as argument in Sumproduct

I'm having a fairly large dataset where I need to combine multiple entries into a single value. My dataset contains data on the combination of two datasets, each using their own ID's and keys.

Visual Studio Windows Forms C# Interop.Excel - Excel Class Object

I have created a C# Windows Form project in Visual Studio and I am trying to work with an Excel workbook via interop.excel. I have created a custom "excel class" and created an object of it in my Form1. What I am struggling with is whether it is possible to open an excel workbook via a button press, i.e. create the class object from a button press, and then be able to use that object in other button presses. Two versions of code are shown below. One works. One does not. The one that works just opens the Excel workbook when the program is launched. The other attempts to use a button press on the form to open the workbook after the program is launched. In the code that does not work, the object "does not exist in the current context". Any help on how to make the button press code work is most appreciated!

How to automatically insert a copied row after a specific value in a cell with VBA

I have a table that contains a set of bundles that have to be broken down into their components. For this I'm looking for VBA instructions that will copy any row that contains the tag "-edubnd" at the end of the 'sku' cell (please see table bellow for example) twice underneath itself.

Laravel get contents of Excel to insert in Database

I'm having a problem while uploading excel file and update data to my database using Laravel 5.6 and Laravel Excel(maatwebsite 3.1) i can't get the contents of each column to update the data in my database.

Excel ROUND function in Javascript

I've got a mathematical formula in Excel, which is the following:

Saving imported excel data in a datagrid to sqlite database

I'm trying to save the data I have imported from excel into my datagrid to my database. Data base details File - tensiondata.db Table - data I can't find enough information on how to perform this, I've attached the code below. I'm not even certain that saving it to a database is the right solution. Is there a way you can save the datagrid somewhere else?