ie-love | : heart : Combo polyfill for IE8 | User Interface library
kandi X-RAY | ie-love Summary
kandi X-RAY | ie-love Summary
:heart: Combo polyfill for IE8 and below.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of ie-love
ie-love Key Features
ie-love Examples and Code Snippets
Community Discussions
Trending Discussions on ie-love
QUESTION
I am reading the names of multiple files in a directory. Each file has a title with five dashes in it. I would like to print these names to a sheet with the titles already separated by the dashes and put into individual cells.
For example, input:
marie-loves-orange-tabby-cats-100
shelby-hates-white-winged-moths-200
Output (where lines represent cells):
Marie | loves | orange | tabby | cats | 100
shelby | hates | white | winged | moths | 200
I hadn't seen a graceful way to print single dimension arrays to cells (although my way isn't terribly graceful either), and the examples I could find did not cycle through changing values. I tried one with simply A:E as the range, but this printed the same file name down the entirety of the cells. To fix this, I made a string with variable values to serve as the range, so that it would only print in those cells and then move down the sheet. A1:E1, then A2:E2, ... so on.
...ANSWER
Answered 2019-May-22 at 14:45From the Str
documentation:
When numbers are converted to strings, a leading space is always reserved for the sign of number. If number is positive, the returned string contains a leading space and the plus sign is implied.
If you Debug.Print "A" + Str(i) + ":" + "E" + Str(i)
, you'll see the leading space and how this is an invalid range reference: A 1:E 1
instead of A1:E1
.
Use &
to concatenate, and avoid Str
entirely.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install ie-love
npm install --save ie-love
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page