Welcome To Snipplr
Everyone's Recent Snippets Tagged excel
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Read data from TXT files to import them in Excel environment
0
890
posted 6 years ago by buglilorenzo
If you've forgotten a password to an Excel workbook that was created in version 2010 or older. See URL for more details.
0
902
posted 7 years ago by cueballrawn
Selecting different values from a data validation drop down list will populate the same cell, i.e. it will create a concatenating list separated by commas.
Amend the "If Target.Column" values to set the columns this applies to.
0
904
posted 7 years ago by cueballrawn
Create a custom right-click menu that will list and launch all macros in the DemonstationMacros module. Copy and past the code into the relevant object or module.
0
1006
posted 7 years ago by cueballrawn
This technical tip shows how to Set Line Spacing of the Paragraph in a Shape or Textbox in .NET applications. You can set the line space of the paragraph, its space before and space after using the TextParagraph.LineSpace, TextParagraph.SpaceBefore a...
0
1833
posted 7 years ago by sherazam
Lists all filenames in a directory if you need them for formulae or add into VBA.
1
935
posted 7 years ago by cueballrawn
Create a bespoke Excel function that allows you to hash (anonnymise / pseudonymise) strings such as unique identifiers. Once you've inserted the VBA, use the function "=BASE64SHA1(cellreference)" to generate the hash.
0
4378
posted 7 years ago by cueballrawn
This code allows you to open an Excel workbook from an Access database and run macros within the target workbook. This could be used to format / clean data prior to import for example.
0
951
posted 7 years ago by cueballrawn
Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.
0
727
posted 7 years ago by cueballrawn
This source code uses public classes and interfaces exposed by GroupDocs.Metadata for .NET to clean metadata from the documents created by a particular author in some directory. Steps include:
1) Scan all documents from an author in a directory (i...
0
867
posted 7 years ago by muhammadsabir
Calculates the center moving average for a time period. The vA requires a range or an array of numbers and the iSteps takes the number of periods in the timeframe (4 for quarters, 7 for weekly, ect)
1
1073
posted 9 years ago by BDOGG32
Two functions that can extract text from a string. Must have the Option Compare Text at the top of the module.
2
841
posted 9 years ago by BDOGG32
Uses regular expressions to do string manipulation. Enter a regular expression into the required parameter and what you want the manipulation to do and it will process the string manipulation. For example if A1 contains John Doe1, Jane Doe2, John W...
2
924
posted 9 years ago by BDOGG32
Code to turn certain feature off and on for faster running of code in Excel
1
1238
posted 9 years ago by BDOGG32
Found elsewhere on the Internet after much searching, this one worked perfectly for me.
0
1339
posted 9 years ago by Dazecoop
Aspose.PDF for Cloud API has released PHP SDK which allows PHP developers to convert PDF files uploaded to a remote server to other formats. You can pass URL and format parameters to specify the PDF’s URL and output format and use the PUT method of...
0
2094
posted 10 years ago by johansonkatherine
The following technical tip show how developers can Convert Chart in excel file to Image in java using Aspose.Cells component. Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, r...
0
1157
posted 10 years ago by johansonkatherine
The following technical tip show how developers can Convert Chart in excel file to Image in java using Aspose.Cells component. Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, r...
0
1104
posted 10 years ago by johansonkatherine
This technical tip shows how developers can split worksheets of an Excel workbook to a separate workbook, TIFF, PNG or any supported image format in the cloud. This example allows you to split all or specific worksheets of a workbook file and save ea...
0
1155
posted 10 years ago by johansonkatherine
`^!d::` hot key is customizable.
`+ ^c^+{+}` is "Shift space ; Ctrl C; Ctrl shift +", stands for "select row; copy; insert".
`{Esc}{Down}{Up}` stands for "leave current copy selection; go down then up (to bring back the selection from the whole...
0
836
posted 10 years ago by Ginko
I wanted a time based gantt chart in excel. Robert's excel template was very useful. The hourly gantt chart was not useful to visualize my needs. I need something with 10 mins precision to analyse patterns in jobs that are running under 15 mins. So t...
0
656
posted 10 years ago by mprabhuram
This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.
0
723
posted 10 years ago by mprabhuram
This formula will automatically change a cell's background color if there is data in it. You can also change the formula to only fill cells where there is no data.
0
685
posted 10 years ago by kidmizere
A combinations of 3 technologies.
Needed to create Excel files within a Python Flask web framework environment and have it sent via HTTP to client to be handled by the jquery.fileDownload library.
Notes:
1. Flask has to set a cookie specified by...
0
1366
posted 11 years ago by doronhor